How to combine two csv files?

Help
1

Hey everyone

Having 2 csv files.Different file name,different values but has same column names.Now i want to combine single csv files.

is anybody can help me on this?

Thanks

1 Like
2

@ganesh_rajan

use Read CSV file activity to read data and will give you output as DataTable and then use Merge DataTable activity to merge both dataTables.

And then use Write CSV activity and provide that DataTable to write into it.

2 Likes
3

Hi @ganesh_rajan

Hope these steps could help you resolve the issue
—use a read cvs file activity and pass the file path of first cvs file and get the output as a variable of type datatable named dt1
— use another *read cvs. file activityand lass the file path of second cvs file and get the output as a variable of type datatable named dt2
— use merge datatable activity and mention the source file as dt1 and destination file as dt2
— this will merge the files into a single file

—once after converting to merged file use write cvs file activity and pass the dt1 as input and output will be a csv file and mention the file path of csv in file input property
https://activities.uipath.com/docs/write-csv-file

Kindly try this and let know for any queries or clarification
Cheers @ganesh_rajan

1 Like
4

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