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

[Marialt]

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

[DataBlender · Accepted solution]

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.