I have multiple csv file i want to merge all at once

Help Activities
, ,
1

I want to merge all file in highlited file

2

@Gaurav_Gore

Use read csv and then use append csv option to add the data without headers

you can as well use merge datatable and then write the data all at once

image
image521×642 28.9 KB

cheers

3

I don’t want to put hardcode csv file name i just want to put which csv file is received first in folder

4

@Gaurav_Gore

Path.GetFileName(Directory.Getfiles("Folderpath","*.csv").OrderBy(function(x) file.GetCreationTime(x))(0)) this will give first file…use this in if condition and also in append csv

Cheers

5

Can u show me the flow

6

@Gaurav_Gore

The flow is same as above screenshot no change…instead of firstfilename.csv use the above expression

Cheers

7

Getting Error

8

@Gaurav_Gore

Please tell what you tried

What activity is throwing wrror and what is yhe error

Cheers

10

@Gaurav_Gore

Can you please show the expression as well which you used exactly

Cheers

12

CurrentFile.Name.Equals(Path.GetFileName(Directory.Getfiles(“Folderpath”,“*.csv”).OrderBy(function(x) file.GetCreationTime(x))(0)))

13

@Gaurav_Gore

Folderpath is replaced with proper path?

Cheers

14

Its working But first file data save two time i don’t want two time

15

@Gaurav_Gore

Try eith Path.GetFileNameWithOutExtension

Cheers