Merge many CSV files of different names in folder

Help Activities
, , , ,
1

Hi,

I have many CSV files with different names in a folder(named Excel_Files) and I would like the bot to merge all these files in an Excel sheet named “Output”.

All the CSV files have the same number of columns and have the same column names.

I did this:

image
image1106×770 33.2 KB

Can someone help me continue please?

Note: I created the variable fileslist of datatype “Array of String”

2

@NIVED_NAMBIAR Can you help me please?

3

@Yudhisteer_Chintaram1 - Please try like this…

image
image993×667 23.9 KB

In the If loop…it will look for output.csv exists…first time file wont be available so it goes write csv and creates the file with headers…second time it goes to append csv and appending rest of files …

Hope this helps…

Note: Change the path in the For Each loop, as per your requirement…

1 Like
4

It works. But I didn’t notice before. I have an excel among it. Can you tell me how to transform all to CSV or Excel before merging them?

1 Like
5

@Yudhisteer_Chintaram1 - Yes…that is doable…Here you go…

image
image1273×616 24.7 KB

image
image947×486 17.7 KB

My Input files

image

My Output

image

Last two rows came from excel file. so it works…

Note: Read Range Output should be saved to datatable called “Dt”…same one we used in CSV.

1 Like
6

Hi @Yudhisteer_Chintaram1 - Did you get a chance to try ? if it worked, please mark my post as solution , that will close the thread and others will benefit from it(finding solved posts).

7

Sorry I didn’t notice your solution.

Can you send me the xaml file please?

is “path” a variable here?

8

@Yudhisteer_Chintaram1 - sure… will share the xaml after sometime.

Path.getextension is a method…

9

Here you go: Merge_csv_excel.zip (45.3 KB)

Run this workflow as is, you will get the output.csv gets created in the project folder…

1 Like
10

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.