Combining Two Tables

[KaraRademacher]

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

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?

[ed_hayter · Accepted solution]

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.

[jrgo · Accepted solution]

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.