Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

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

Marialt
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

1 REPLY 1
DataBlender
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