Getting row index of a row in a datatable inside another datatable for each loop

I have two excel files (one is “main” file and another is “input” file). For each row in “input” file I need to extract 4 values from different columns and one after other filter “main” excel dt to get 1 final row (based on those 4 values) and then update one of the column of that filtered row in “main” with one of the value from “input”.
Now what I have done is applied foreach row on “input” dt and filtered “main” dt with values extracted from “input” dt. But now to update the value of one of the column in “main” (directly into excel) I need to know the index of that filtered out row.

How can I do that.
Thanks in advance


Try this:


1 Like