Two csv files, want to write data from one file to another

Help Activities
, ,
1

Hi, I have Stuck in a problem, problem is that I have two csv file I want to extract data from one file and check condition using "if "and if there is a match than want to put it into another file using column name.
I am able to extract data from one file and also check successfully using if but when I try to put it into another file I find some error. I am using (dataset1.Rows.Item(“mac_id”)=CurrentRow.Item(“mac_id”)) expression where “CurrentRow” indicate the dataTable of csv file from where data is extracted and “dataset1” is a dataTable for csv Where i want to put the value.
Can you please help on this.
Thanks in advanced.:blush:

Capture
Capture1151×599 40.9 KB

1Capture
2Capture
2Capture697×490 12.2 KB

3Capture
3Capture789×514 13.4 KB

4Capture
4Capture791×488 11 KB

2

Hello,

Instead of using assign activity, can you please try to use add datarow activity to add the data to second datatable and see if it’s working? Here, 2nd row is not present and you are trying to add a value there. To double check, you can get the no of rows in 2nd datatable using : datatable2.rows.count.tostring

Thanks,
Athira