How to delete row that contains keyword in the datatable

Learn Academy Feedback
1

Hi all, I want to delete the 1st,2nd,3rd row in the data table. I tried to use the Filter data table activity. But the first row contains the column name, so I fail . How should I do ?

%E5%B0%8FQ%E6%88%AA%E5%9B%BE-20190323135250

2

I want to delete the row with the keywords "Check " “Sum” "Subtotal "

3

@Katrina2018,

Use Insert/Delete Rows activity to delete rows. Here, you specify below details to this activity.
No. of rows: 3
position:1
ChangeMode: Remove
SheetName: your sheet name

4

@Katrina2018
Refer below thread…

Regards,
Monika

5

Hi @Katrina2018
Try below code

dt= dt.select("Column2 not in ('Check','Sum','Subtotal')").CopyToDataTable()

Regards,
Arivu

1 Like
8

@monika.c I tried the method, but will delete the column “PLU” as well . How can i just remove the row with keyword while without any effect to other column . test.xlsx (11.1 KB)
Flowchart.xaml (12.9 KB)

9

@arivu96 Seems sth error. Would you help to fix my template ?
%E5%B0%8FQ%E6%88%AA%E5%9B%BE-20190323150601 Flowchart.xaml (14.1 KB)

10

@Katrina2018,

Have you tried with this activity ?
Please find the attached workflow. Change excel file path and mention sheet name to which you want to delete data.
Excel.xaml (6.6 KB)