Get the name of file.csv and continue with the number dynamically

[Anil_G (Anil Gorthi)]

@pprin001

So to get the latest file you can use below

latestfilenumber = Cint(Path.GetFileNameWithoutExtension(Directory.GetFiles("FolderPath","*.csv").OrderByDescending(function(x) Cint(Path.GetFileNameWithoutExtension(x)))(0)))

This will give you the latest number filename in integer format…

Now use (latestfilenumber +1).ToString for the new file

For writing datatable to csv please use write csv activity…

Export to CSV "write from" Problem

@Anna.Dewitt Please use write csv/text file activity … The activity which you are using expects a excel sheet reference directly but not a datatable… A data from datatble can be written to csv using write csv Else if you want to use the same above activity as in screenshot then please click on plus and select custom input and provide the sheetname (eg:Excel.Sheet(“sheetname”)) Cheers

Cheers