Data comparison workflow - two sets of data from many sources

[DXCTech]

Hi,

I need a workflow to compare two sets of information. Each set of information sits on our sharedrive in ~25 files with varying formats. 

In a perfect world, I would be able to get a listing of all the files in our two folder locations, pick the ones that I want to compare, pick the tabs from each file I want to compare, and then compare the values in the two datasets against each other. 

I know this would be simple if the workbook structures were the same and the tab names were the same, but they are varying. Is there a macro I can use to help with the varying data structures and varying tab names I need to pull from all these workbooks? 

Thanks in advance!

[bensilv]

Hi DXCTech,

Worth taking a read of this article - https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/The-Ultimate-Input-Data-Flowchart/t...

Additionally there is a macro to read in dynamically - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Input-Batch-Macro-AKA-the-Extra-Dynami...

Hope it helps!

Ben

[Felipe_Ribeir0]

Hi @DXCTech 

With the batch input macro (that @bensilv  shared) you will be able to import all files.

With Expect Equal macro you will be able to compare the two different sets of data.

You can download and install it from here:

http://www.chaosreignswithin.com/p/macros.html