Alteryx designer Discussions

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

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

Atom

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

Highlighted
Bolide

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

Labels