Update the data in every row in csv

[hemadri_kamatham (hemadri)]

Hi,

How to update a particular cell value in every row,
My scenario is i am reading a csv file into a datatable and i am itterating by using “for each row” activity,now in my scenario for every completion of each row one client id will be generated,i captured that client id into one variable,now i want to insert that variable value in the last cell of every row,so that i came to this row data generates this client id,how to do this.

kindly help me out to complete my poc.

Thanks&Regards,
Hemadri

[hkjobs1988 (Hitshs Kumar)]

Check if these 2 workout for you

Update a cell in looped row

Hi, picture talks louder than words. [status]

Update each row in an Excel document

Hello, easy, I would suggest you to write on a particular cell if the row or data has been processed. then every time you run the artifact make it read the cell that could indicate if the process has been done. and move to the next. here is an example. faite0.zip (13.6 KB)

[Srilatha]

Hi,

how can i compare each single row in “sheet 1” with other row in " sheet 2" and if they match i should update in the status column.then it should go to second row and so on.pease help me with that.