Comparing Data from Two Sets of Data, Calling out Differences
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
You just saved me so much time! I was trying to find an alternative to doing a join on every single column. Whew.
http://community.alteryx.com/t5/user/viewprofilepage/user-id/2328
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@anthony, Thank you so much for the help. It works well on all types of data.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
This was very helpful
- « Previous
-
- 1
- 2
- Next »