Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.
SOLVED

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

Highlighted
5 - 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

11 - 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