Combining the Excel files with number of sheets

[ravikumar060987]

Dear All,

I have a situation, in a folder have 30+ xlsx files. Need to combine all and where each excel file has 2 sheets.

Sheet 1: Summary - not to combine
Sheet 2: Actual Data (Which has 12 common headers across all the 30+ files).

How can I do this in Alteryx without using a macro?

[ShankerV]

Hi @ravikumar060987 

Step 1: Directory tool, to read the full path of the file.

Step 2: Formula tool, to read only sheet2.

[FullPath]+'|||Sheet2'

Step 3: Dynamic input tool.

Expected output:

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V

[ShankerV]

Hi @ravikumar060987 

FYI, the output will be read in the ascending order of the filename it read as per the directory tool.

If you need to change the order, use the any tool/method in which you need to sort and read the files.

The sorting is based on your need.

If this helps, please like this post and mark it as a solution. If you have any other questions, please let us know.

Many thanks

Shanker V