Data Consolidation

[Learner09]

Hello All,

I have approximately 20 files in a folder, with some files having the same names and others different. Each file contains multiple tabs, but one common tab across all files is named "Data." My requirement is to open each file, navigate to the "Data" tab, and extract data where the "Product" column contains "HDW." I then need to consolidate this data into a single output file.

I've attached a sample file for reference. Could you please guide me in designing the Alteryx workflow to achieve this?

Thank you!

[OTrieger]

@Learner09 
You can do it with a batch macro.

[JosephSerpis]

Hi @Learner09 have a look at this article it will explain why you need to use a batch macro to tackle this challenge and has an example. In screenshot for batch macro you will see that it references adding sheet to the path in your scenerio it be adding Data to the filepath.

[Learner09]

Thank you!