Dynamic Comparison of Columns name from 2 sheets

[Ash_11]

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. 

[ChrisTX]

See these related posts:

Community > Support > Knowledge > Designer > How To: Compare Data from Two Data sets

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Compare-Data-from-Two-Data-s...

Comparing Data from Two Sets of Data, Calling out Differences

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Comparing-Data-from-Two-Sets-of-Data-C...

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

https://community.alteryx.com/t5/Inspire-2019-Buzz/Nested-Macros-Session-Field-Comparison-macro/m-p/...

Iterative Data Comparison

I am looking to compare data between 2 files - Pre and Post. 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Iterative-Data-Comparison/td-p/841398/...

Combining 2 Data Sets and Highlighting Differences in Output

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Combining-2-Data-Sets-and-Highlighting...

Chris

[Ash_11]

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.

[ChrisTX]

In the first link I sent, the macro is dynamic.

Chris