Join Multiple Excel Files to One File

[Ar13f]

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

[atcodedog05]

Hi @Ar13f 

Try this

Hope this helps : )

[Ar13f]

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

[atcodedog05]

Hi @Ar13f 

I am good. Hope you are doing good to : )

Didn't the attached workflow work for the task. You just need to update the folder path in the directory tool and it should read all files and sheets. Let me know if it doesn't and what issue you are facing.

Hope this helps : )

[Ar13f]

Dear @atcodedog05 

sorry for interrupting your time, can you provide the workflow from the data I provided in the attachment?

[atcodedog05 · Accepted solution]

Hi @Ar13f 

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 : )

[Ar13f]

Dear @atcodedog05 

please find attached file for the expected file ...

[atcodedog05]

Hi @Ar13f 

Dynamic solution for this would not be possible.

[Ar13f]

Dear @atcodedog05 

thank you for your response ...