I have created a workflow that joins two tables. One of the tables is from an external source and the other table I have created via the text input tool
When joining on the left output I have items that do not appear in the text input table and the join is everything else that matches.
In Microsoft access I would normally write a query that would then append the items that do not join (left join) to the equivalent of the text input tool.
Then when I run the process again, I wouldn't have any unmatched items in the left join.
How can I do this in Alteryx
Many thanks
Solved! Go to Solution.