Comparing two files and Spot differences

@messi007 Thanx for your response. But the challenge is the two files has 18 tabs each and all of them needs to be compared. In that case can we have a more dynamic solution.

messi007

@DataPirate26,

You can union the files and then use the same process to compare.

Below how you can read multiple tabs : https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets-or-a-Specific-Excel-Range/ta-p/398220

Hope this helps!

Regards,

DataPirate26

@messi007 The issue is not with unioning the Files. I have created a batch macro and I am able to read all tab data. from both the files. But how to take each field individually and then compare one by one. That would take a lot of time I guess. Can we not have a more dynamic solution which will compare the entire data at once.

Also I will have to split the dataset into 5 separate outputs which again have sub tabs in them and all of them have different headers but the colour logic will apply for all of them.

messi007

@DataPirate26,

Here you go :

Attached the new workflow,

Regards

Copy of Difference workflow_Autosave.yxmd

DataPirate26

@messi007 I have 18 tabs for both Files and Each tabs in an average have 10 fields. In that case it would be difficult to compare each field one by one and This isn't working also. Also the Output need to splitted into 5 different Output files.

sulebraimah

I am fairly new to alteryx, i am needing help. I currently have a vba nacros excel built by someone who no longer works in my department. we update some rules on a weekly basis and at the end of the excerise we pull the updated rules from SAP and use vba macros to compare the requested update and the global list, macros currently returns the attached picture. but the problem is, it doesnt recognize underscore and numbers, i am looking to use alteryx for the same thing. is there anyone who can help.

sulebraimah

so basically the end product i need is for alteryx to spit compare the rules i added to the list after adding them with each field added coming back as either match, deleted , or mistake. The headers im comparing are in the picture below

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703