Remove row from excel sheet

Help Forum
,
4

Hi @sshitol ,
use read range to get the data into datatable and use below query to filter

use assign activity to achieve this
DataTable = DataTable.Select("NOT (LEN(Ticker) = 5 AND Ticker LIKE '%XX') and Weight>0").CopyToDataTable()

then use write range

Regards,
Arivu