Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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!

13 REPLIES 13
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. 

saurabhkunal12
5 - Atom

This was very helpful

Labels