Multiple CSV to Datatable

Help Studio
, ,
1

Hi,

I’m using for each to iterate over two csv files, so I’m having for each activity and inside of it read csv activity. Seems to be ok, but when checking xlsx file I have content from last csv only. Question is that how to append data from both csv files to datatable ?

I need to use for each from scalability reasons…

Example would be perfect :slight_smile:

image

2

@JRii,

If you are reading data from CSV files and writing it to a single excel file, then use Append Range activity instead of write range.

1 Like
3

Thanks from the effort, but not working.

Thinking that I should somehow merge iterated datatables. Trying this currently via merge activity, but from some reason now getting error … Object reference not set to an instance of an object.