I used to use Write Range, and overwrite a signle row with it’s index, this way, i was able to update the row needed. Now, I need to remove the write range, so I need to find a way to overwrite the row like used to do on the Write Range. Any ideas ?
@maroua301
You should be able to use a for each row in DT to do this. You can update the values using row(“columnName”) in an assign and assign it a new value.
it seems you just need to replace a row content only.
that can be done using for each data row loop, find the particular row using if statement, once found replace it
OR
you can get row index using LOOKUP Datatable, mention the row element you need to search and the column in which that row element will be and then update that particular row with that found index
I appreciate your help, but that’s not what I’m looking for. I’m using the reframework, in each transaction, i get the whole row, using this io_dtDC.Select("[JK]='"+in_TransactionItem("JK").ToString+"'").CopyToDataTable(), later I used, to use write range, in the end of each transaction, with the index of the current row. Now I’m trying to find a way, to store all that transaction, in a DT, until the end of the process.