Dynamic Comparison of Columns name from 2 sheets

Question

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.

TestFile - Copy.xlsx

ChrisTX · Answer

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

Chris

Ash_11 · Answer

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 · Answer

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-sets/ta-p/9414

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-Calling-out-Differences/m-p/63727#M23078

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-servers/td-p/517599

Compare field values Left vs Right

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

Iterative Data ComparisonI 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/page/2

Combining 2 Data Sets and Highlighting Differences in Output

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Combining-2-Data-Sets-and-Highlighting-Differences-in-Output/m-p/956626#M235653

Chris