I know there is a thread on Deleting Rows from a datatable, I had gone through that, and had posted my challenge there, but got no response, so trying with a fresh thread.
I have a DataTable with “No headers”. Its reading from an excel file and there are few rows in it with 3 columns each. The first column is a string . What I am trying to achieve is to Delete the rows that have the value “Engagement” in the first column.
I traversed through the datatable using For each… and used the assign activity to select the row with engagement as follows
It gives me an error that Column0 not found. I was able to do the below assignment successfully.
Can someone help me achieve this using the Remove row activity or a regular For loop.