Remove rows Containing a Keyword A3

Dears,

Could you please help to delete rows containg Keyword “A3” in column “D”:

image

Thanks in advanceExample.xlsx (8.9 KB)DeleteRowsContainingKeyword.xaml (11.5 KB)

Hi @hsendel
we can use
Filter datatable activity and option Remove radio button chosen
and columnname as “Item Type” and condtion as = and value as “A3”

Cheers

1 Like

Hi Palaniyappan,
I did the same but didn’t help.Could you please check.ThxDeleteRowsContainingKeyword.xaml (10.6 KB) Example.xlsx (8.9 KB)

1 Like

HERE YOU GO
hope its resolved
hsendel.zip (10.7 KB)

Cheers @hsendel

1 Like

@hsendel try below

dt = dt.select("ColumnName not like 'A3'").CopyToDataTable

So need to create new dt for output and new sheet right?

1 Like

Thanks Akshay, Possible to rebuild that using my example?

no not at all
kindly have a look on this

i haven’t added any new dt
just filtered and wrote them to excel
Tried to come up with simple steps that could help you
Cheers @hsendel

1 Like

I attached your xaml after modifying it a bit…

DeleteRowsContainingKeyword.xaml (9.8 KB)

Hi Akshay, I got the following : image

1 Like

@Akshay, This error fix"d by changing data by dt in Datatable but still nothing was removedDeleteRowsContainingKeyword1.xaml (8.6 KB) Example.xlsx (9.0 KB)

1 Like

Hello @hsendel I am sorry for late response…
written result were not filtered because of variable assignment error from my side…
instead of assigning to dt I was assigning filtered result to data_to_del and I was writing dt

Updated xaml… DeleteRowsContainingKeyword.xaml (9.6 KB)

1 Like

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