Read Multiple files with multiple Sheets === Output 1 File with same multiple sheets

[Sanjeev75]

Need help to solve this problem.

I have multiple files with multiple sheets. What to read all the files and their respective sheets and output into one file with the respective sheets, appending the data of the respective sheets.

[Manoj_k]

There are several workarounds that we can use to achieve what you're looking for. It's a bit more complicated.

The Alteryx input tool has a function to obtain the sheets that are part of your Excel file. It would be done as follows.

Once you have the list of sheets in that configuration, in the tool's configuration itself, you need to output the full path of the file as shown in this image.

Once you have this, it would be as simple as adding this formula tool with a replace function like this:

By filtering for the sheet you want with a filter formula and placing a dynamic input behind it, you will be able to open all 6 sheets just by bringing in one file, as shown in the attached image.

[Sanjeev75]

The sheet names will be dynamic. Attached is the solution so far but the issue is am getting all the column headers combined.

What I want is, data should append to the respective tabs with respective column headers only.