Compare 2 Excel workbooks

[saiirangam]

I am trying to create Dynamic Alteryx workflow to compare 2 excel workbooks , I need some help and guidance to complete it.

The workflow should run for different set workbooks not only specific data

[gawa]

hi@saiirangam 

If you want to compare two excel workbook, and unknown schema, recommend to transpose data into vertical shape, and check difference by join tool.

If you wanna check difference visually, and can accept to use macro, Crew macro is nice.

Refer to attached workflow.

[saiirangam]

Hi @gawa

Thank you for response. 

  Could you please attach the Macros related to this workflows

[gawa]

hi @saiirangam 

Sorry for late response. Please visit the below site to install Macro. This is called "Crew Macro", which is frequently used in weekly challenge.

http://www.chaosreignswithin.com/p/macros.html?_ga=2.231908831.1183052243.1687250043-1536619432.1687...