Combine 3 file (xls,csv) to new file (excel)

[fairymemay (noona)]

I want all file in folder File input [combine 3 file (xls,csv)] to new file (excel)

File input : File input.zip (21.8 KB)

File output : output.xls (58.5 KB)

*same format original file.

Please guide me about it. (solve by uipath or macro)

[fairymemay (noona)]

Please help me for solve it.

[ganesh4 (Ganesh)]

I saw your files. Each file has different formats. So you need to prepare that files before you are going to do comparing

[fairymemay (noona)]

@ganesh4 I don’t compare file.
I want to combine 3 file to 1 file (3 sheet)

[ganesh4 (Ganesh)]

Yes. Because all three file has separate formats. so

1st:- Use skip and take concepts only table format whichever you want

2nd:- skip and take will give one data table structure then you create one combined file

Repeat this concepts for 3 files and then will get one single output file

[ganesh4 (Ganesh)]

Here I have attached few reference for you

[prasath17 (Guru)]

@fairymemay - Please find the xaml and output files attached…
Merge_csv_xls.zip (98.8 KB)

Here is the final output…

Hope this helps…

[fairymemay (noona)]

@prasath17 After run completed.

I open file it show popup as below.

If I click yes data in file as below.

Please guide me for solve it.

[prasath17 (Guru)]

@fairymemay - Did you followed the instruction correctly as I noted in the starting of the workflow??

You have to create the empty Merge_Output.xls first in the output folder and then run the workflow.

[prasath17 (Guru)]

@fairymemay - please find the updated workflow…
Merge_csv_xls_Update.zip (79.5 KB)

now , you don’t have to create the output file first. It will created by the first activity.