Dynamic Comparison of Columns name from 2 sheets
- 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
Hi,
I have two excel sheets, where in Sheet 1 contains 40+ columns and Sheet 2 Contains 50+ columns with data in it. Now, i need to make a comparison of two sheets, where in the same column name should be compared and if the value in both sheets is different, then i need "False" flag and if it is same then a "True" flag and for the remaining 10 columns it should be highlighted with a color. As the no.of column is high, it is tedious to map each column with one other. Is there any way, that we can do it dynamically.
Attaching the sample file for your reference.
- Labels:
- Dynamic Processing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
See these related posts:
Community > Support > Knowledge > Designer > How To: Compare Data from Two Data sets
Comparing Data from Two Sets of Data, Calling out Differences
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/String-Comparison/m-p/388279#M71158
https://gallery.alteryx.com/#!app/CReW-Delta--Alpha-/5b41141b826fd3116445fee8
Compare 2 Data Sets
https://community.alteryx.com/t5/Engine-Works-Blog/Compare-2-Data-Sets/ba-p/88853
Community > Getting Started > Alteryx Use Cases > Data Check Between Two Sources
https://community.alteryx.com/t5/Alteryx-Use-Cases/Data-Check-Between-Two-Sources/ta-p/270082
Comparing data between two different servers
https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Comparing-data-between-two-different-s...
Compare field values Left vs Right
Combining 2 Data Sets and Highlighting Differences in Output
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thanks Chris!
I wanted to perform lookup between two sheets, where in my column names should be dynamically picked (same column names in both the sheets needs to be compared dynamically and should give a output of true or false), instead of mapping the column to one other. Also, my data fields are high, i have nearly 50 columns in each sheet. Can you please help me on this.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
In the first link I sent, the macro is dynamic.
Chris
