How to solve this error when I deleted column?

Hi guys…
How to solve this error when I deleted column?

Collection was modified; enumeration operation may not execute

1 Like

Buddy @Lwin_Moe_Aung don’t try to delete the column when you are in for each row loop, better use for each loop with input as datatablevariable.Rows

The reason why you get this error, while being iterated through the datatable, and if we try to make even a small change in the existing datatable(which is getting iterated now), we will be getting this error…

you can not the delete the entire datacolumn from data table using for each, instead you can empty the column value of that particular row,

to delete the entire column you can use the activity Remove Data Column outside the for each activity.

Let us know if this helps,
Pavan H

1 Like

@pavanh003 @Palaniyappan
Thanks you for your reply…
Your answer helps me a lot.
I will search next methods.

Lwin Moe Aung

1 Like


If I want to check for a particular column and if it is there remove all other column …then how to solve this issue.