Remove rows Containing a Keyword A3

Help
1

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)

2

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
3

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
4

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

Cheers @hsendel

1 Like
5

@hsendel try below

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

6

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

1 Like
7

Thanks Akshay, Possible to rebuild that using my example?

8

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
9

I attached your xaml after modifying it a bit…

DeleteRowsContainingKeyword.xaml (9.8 KB)

10

Hi Akshay, I got the following : image

1 Like
11

@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
12

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
13

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