For each row & Add data row : Collection was modified; enumeration operation might not execute

Help Studio
, ,
1

Screenshot (82)
Screenshot (82)1920×1080 283 KB

Hi All,

I am facing the error i.e. " Collection was modified; enumeration operation might not execute." while using add data row in for each datatable.

in this add data row I am passing lookup variable here I am write that data on a particular column.

2

Hi,

We cannot add or remove row which is iterated collection in for each loop.
If you need to just update target column value in existing rows, Can you try as the following?

image

Regards,

3

Screenshot (83)
Screenshot (83)1920×1080 280 KB

I am lookup the dt and write value through add data row

4

Hi,

If you need to add rows to dt_consolidate, the following RepeatNumberOfTimes activity might help you.

image
image1083×724 35.6 KB

Regards,

5

I am sharing code with you.
test.xaml (17.2 KB)

6

Hi,

Can you share what you want to achieve?

Regards,

7

input.xlsx (12.0 KB)
In this file there is an output sheet in which i have shared output of this process.

8

Hi,

Probably, you don’t need to use AddDataRow.
In this case, can you try to put Assign just after LookupDataTable as the following?

image
image763×566 18.3 KB

Regards,

9

ok I’ll try