Delete the row if column has "0"


#1

Hi,

I am trying to delete the whole row of an excel sheet if column H has “0”. But getting the following error: Collection was modified; enumeration operation might not execute.
I have attached the file. Could anyone help

Pilot_Refresh_MB5B_MB5T.xaml (10.2 KB)


#2

hi @nikhilaramesh08,

use assign activiy
dt=dt.select("[Total Receipt Qties] <> '0'").CopyToDataTable()

Regards,
Arivu


#3

Found the answer: Delete data row from data table


#4

Thanks Arivu