Always remove DataTable rows with the same name

Help Activities
, , , ,
1

Hi everybody,

is there a way to remove rows in a datatable at once? (Highlighted in yellow) The rows always have the same cell notation:

  • "Vormontage: Bandmotoren,
  • Vormontage: Gestell + A-Box GLM-Ievo
  • Vormontage: Halter Bottom + Eti Bottom
  • Inbetriebnahme: GLM-Ievo
    So, if the cells exist they should be removed from the data table.

Additionally, the column “Dauer der Bearbeitung” has to be sumed up.

Do I need to save the Datatable in Excel? The Datatable is extracted from SAP and if it’s possible I don’t want to save it in Excel.
2021-12-02 14_50_55-Mappe1 - Excel

Thanks a lot for helping!
Greetings
Agnetha

2

Hi @Agnetha

Try with filter datatable by giving

“Vormontage:*” as your value

Regards
Sudharsan

1 Like
4

@Agnetha

Try as below for the removing rows which has the notations you listed

image

You can add as many notations according to your use case

make sure that Remove rows are selected

Thanks

1 Like
5

@Agnetha

For sum all values check below post

Hope this will help you

Thanks

6

Hi ,

For your requirement invoke code is the best solution. We can write vb.net code to filter the rows with the specific word and delete them at a single shot.

Atlast we can use write cell activity to insert sum formula to sum the values.

In the above case no need to insert data table into Excel. Datatable concept will not come into picture. Thanks.

7

Hi all,
thanks to all of you for the input :slight_smile: Removing the rows by filtering worked perfectly!

1 Like
8

@Agnetha

Glad, My inputs helped you
Happy Automation

Thanks

9

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