Using Data Joins - Limits to Join Data?
I have a data set of about 400K rows of sales data. It includes our item code, but no other details. I'm trying to match it to our item master, which has about 2K rows to fill in the blanks. I know there is a limitation to the left dataset in a join, I believe it's 10K rows, so I'm using the item list on the left and the sales data on the right. In both tables, the item code is text, and Domo agrees on the data type.
However, when I run the dataflow (in preview or in full) it does not join the data. I get 400K rows of sales data with blank item columns where the extra details should be. Are there any limits or best practices to guaranteeing two text columns match up?