Data comparison workflow - two sets of data from many sources

Question

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!

Felipe_Ribeir0 · Answer

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

bensilv · Answer

Hi DXCTech,

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

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

Hope it helps!

Ben