In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Combining Two Tables

KaraRademacher
7 - Meteor
 

This is what I am currently getting when I combine the two tables in the workflow.  I'm using a union.

 

Alteryx Output.JPG

 

This is what it looked like when I performed this in excel previously.  I would like to replicate this process in Alteryx for me.  Can anyone assist me on how to get the outcome to look like the below?

Excel.JPG

2 REPLIES 2
ed_hayter
12 - Quasar

Rather than a union you'll likely want a join tool with the join clause specified as status = status. If you have the previous data coming into the right input anchor then rename right_count to previous and count to current. Use a formula tool to compute the change.

image.png

 

jrgo
14 - Magnetar

You want to use the JOIN tool, not the UNION tool.

 

Join tool will give you a similar behavior as an Excel VLOOKUP. The Union tool simply stacks data.

Labels
Top Solution Authors