Alteryx Designer Desktop Discussions

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

Comparing Data from Two Sets of Data, Calling out Differences

egorman3
5 - Atom

I need help comparing an old set of data to a new set of data and creating a list of all changes. The problem here, is there is about 15 columns and every column could potentially change in the update. 

 

Any help is appreciated. I have attached one sample document, this would just be updated monthly with updates or changes to the columns.

 

Thank you!

12 REPLIES 12
SamDrury
7 - Meteor

Hi Domo,

 

Would it be possible to attach your workflow with a small sample data set? I'm happy to take a look. 

 

> Does 'Unique' tool has any limitations as I was comparing double data?

 

Not that I'm aware of - I can't see anything on the tool page here

 

Thanks, 

 

Sam

ThizViz
11 - Bolide

You just saved me so much time! I was trying to find an alternative to doing a join on every single column. Whew.

@thizviz aka cbridges, Bolide
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
Aparnadevij
5 - Atom

@anthony, Thank you so much for the help. It works well on all types of data. 

Labels