Join Multiple Excel Files to One File

Dear All,

I have several files in one directory as below, what I want to do is combine the data into one file with a sheet name that matches the file name below.

I completed the step above, however the data from the above file is not properly stored in the file.
Only the sheet name is saved, but no data is preserved.

is there an error in my workflow? Need advice from you.

Thank you and regards,

Ar13f

Datasets

Join

In Database

Database Connection

In-Database

Accepted answers

Can you tell what the expected output for this will look like. I can work towards it.

Currently, output is looking like this. Attached the workflow input file are in Input folder.

Hope this helps : )

Multiple Excel Sheets Multiple Files.zip

All comments

Try this

Hope this helps : )

Multiple Excel Sheets Multiple Files.yxzp

Dear @atcodedog05

I hope you in good health ...

Really appreciate for your prompt response ...

Actually I just want to combine several files with different sheets into one file according to the sheet, like the "move or copy" function in excel.

So I have:
1. DPD file with sheet name "DPD"
2. FSL files with sheet names "SB","KP","LC", and "BG"
3. SMY file with sheet name "DPD2"

I want to combine these sheets into one file to make it easier to read, one file consists of:
1. Sheet "DPD"

2. Sheet "SB"

3. Sheet "KP"

4. Sheet "LC"

5. Sheet "BG"

6. Sheet "DPD2"

Thank you & Regards,

Ar13f

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15872

MarqueeCrew 13708

apathetichell 13703