Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Appending Data to a Text Input table (created in the workflow)


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


Hi @Marialt, you can add a Union after to union the results of the left and inner outputs:


Here's a link to a useful resource for translating database joins into Alteryx.


Join with Union.png