Remove/Delete rows

Help Robot
,
1

Hi team , i want to filter or delete those Credit amount column which have blank amount
and in description column starting from sweep , salary payment

image
image1312×343 6.79 KB

Please help

2

Hi @Kuldeep_Pandey

Try with Filter Data table activity to remove the empty column in the Credit

image
image705×279 15.5 KB

image
image782×316 19 KB

Regards
Gokul

3

Hi @Kuldeep_Pandey,
use below syntax in assign activity to filter the re
dt=dt.Select("(DESCRIPTION like 'SWEEP%' or DESCRIPTION like 'SALARY PAYMENT%') and CREDIT=''").CopyToDataTable()

Regards,
Arivu

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.