Union/Compare two inputs

[Kureel]

I want to compare two inputs in Alteryx that have same criteria but different names. compare the two data sets side by side and then calculate the difference. can someone please help?

[binu_acs]

@Kureel 

[Kureel]

@binuacs does the difference column have to be a manual process of adding new columns each time? I may have hundreds of data that i need to compare and adding hundreds of columns seems inefficient 

[gabrielvilella · Accepted solution]

Hi @Kureel, it is better if you work with your data in rows. See the solution, you don't have to manually create each difference.

[Kureel]

@gabrielvilella thank you so much! works great!