For Join, I'm just doing a left join. Fields are both Strings. It works in Alteryx, so no idea why it's not working in Snaplogic. I also tried In-Memory Lookup but the fields are just not joining. Only the left path fields come through. What could be causing this?
Solved! Go to Solution.
Are you validating the pipeline or executing it? Try executing and see if you get any matches. When you execute, the Join will process all of the input from each input view -- you'll operate on all of the data. If you're validating, keep in mind that the number of documents processed by the Join for each input view is limited to the Preview Document Count configured in your settings. This is only 50 by default. So if you have a lot more than 50 rows of input for each view, it might be that there's no matches in those first 50 documents. Try increasing that setting from 50 to a larger number like 2000.