For each row in datatable uses same values each loop

Help Studio
2

Hi Amrish,

Welcome to the Forum!

Do not use ‘Dt1.Rows(0)’ in your assign activity. It will always refer 1 row of the table. You have to use ‘CurrentRow’ or ‘row’ variable from the ‘For each row’ activity. So your assign activity should be like below.

Column 1 = CurrentRow.Item(0).ToString

1 Like