Index not matching

Help Activities
, ,
1

i have exel data with filter applied on one column in data table and reading the values and in for each row in datatable DT1 the current row value DT1 and matching that value in another sheet in DT2 when value is matched i want to update a cell value in DT1
but when iam wring on cell it is writing on first cell of the column

where as current row item in it DT was at index 45 …i want to write in same index of that current of DT1

here iam iam reading the data of DT1 with filter applied where some rows data is hidden is that making a problem

2

Hi @T_Y_Raju ,

Use the lookup datatable activity to get the index and use the index to add to write cell .

This approach will help u .

Regards
Sandy