In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
Start Free Trial

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
Top Solution Authors