Multiple Sheet to Consolidate

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

Book1.xlsx

Help

Accepted answers

jasperlch

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.

All comments

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

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.

Thank You

Quick Links

This months top contributors

LanisC 335

hhaigh1 280

erich_shiino 280

FláviaB 262

JORGE4900 235