Multiple Sheet to Consolidate

[Shank]

Spoiler

HI all,

I need to consolidate the multiple file to one single file in alteryx can some one help on this?

Below is the scenario, i have multiple excel files in one folder.

each file has 3 different sheets. i need out put in such a way that all files sheet1 should be clubbed into 1output  and sheet2 in one file and respectively for sheet3.

Attached the sample file for example.

Thank you in advance

[JoeS]

I think you might want to take a look at the Wildcard XLSX macro that's part of the CReW macros pack.

You can find the details about the Wildcard XLSX macro here

And the latest download here

Note: the Enter sheet names at the bottom is to Exclude those sheets, not read them ;-)

[jasperlch · Accepted solution]

Hi, using wildcard in the path of the input tool works well if the sheet names, the sheet schemas (i.e. the names and number of column headers) are consistent in all of your excel files:

Attached are a sample workflow and some sample excel files to work with this workflow.

[Shank]

Thank You