Removing Data Rows from Excel/CSV Files

I am using StudioX and have a 20,000 plus row Excel/CSV File - which can vary with each iteration of the process.

I need to remove row data based on certain criteria from within that file

I have searched the web and seen that there is a Remove Data Row activity which doesn’t seem to be available in StudioX

Can anyone assist please with the best option to move this forward

Possible solution:

  1. Open CSV in Excel
  2. Filter based on your condition
  3. Delete visible rows
  4. Clear the filter

Data table activities have started to roll in StudioX. RemoveRow has not be added yet, but maybe you can use FilterDataTable instead:

1 Like