Manipulate Columns of a DataTable using For each

Hi All,

So I have this large datatable and I want to multiply all the values in a particular column of the datatable with a partcular variable. That particular column has no name too, So I intend to target its values using column Index.

for example
1

becomes
2

Hi @Odunayo_Ogundepo,

Please find the attached workflow for your reference.

AccessColumns.zip (22.6 KB)

Thanks,
Tuhin

1 Like

Hi @Tuhin_Samanta

Thank you very much for the help, but every time I run it I keep getting this error

For Each Row: Collection was modified; enumeration operation might not execute.

any ideas on how to fix this?
Regards,
Odunayo

1 Like

Did you try the work flow I attached. It should work fine.
Collection was modified error comes when you try to modify the same collection inside the for-each loop which you are iterating.

1 Like

It worked!

Thank you very Much

Regards

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.