I have a report just under 3,000 rows. (Left Table)
I have a master list with just over 20,000 rows. (Right Table)
I'm applying a filter to narrow down the master list and then using Left Outer Join Data to pull matching criteria using an email address as my join key. Unfortunately I'm not getting all data from the master list (Right Table). Spot checking both lists before the Join Data shows all data is visible. After the Join Data only about half the rows have the data from the master list and is showing null while all rows from the report have the expected data.
Any idea what might be going wrong? I've use the Join Data function a few times and haven't run into this issue. I've tried to delete all datasets and ETL and recreate and the same thing keeps happening.