Delete rows based on value in one column

Help Studio
, , , ,
1

I have a datatable
Input
image

I want to delete the booking group if any rows in Note column contains any text.

Output I want

image

I do currently have a solution (pics below) but it a long process. Just wondering if there is any other simple solution.
I can group them by

image
image1474×515 24.5 KB

image
image1023×605 26 KB

image
image862×245 7.73 KB

image
image829×536 13.3 KB

2

Have you tried using the filter datatable activity?

Filter Data Table (uipath.com)

3

@SenzoD yes but that won’t help me as I need to delete booking ID group if any row contains data.

5

@ravindar.singh Refer this .Xaml File.
Testing.xaml (10.6 KB)

1 Like
6

Hello @ravindar.singh,
From my understanding of your problem,
you could try to check if there is values in the column first then
create List as `Black list’ to save the Booking ID value at it.

after that do for each item in Datatable and delete any row that has Booking_Id value in the list ``BlackList.

I hope I could help you,
happy automation :robot: .

3 Likes
7

@sb001 I am kinda already doing this but now I found a simpler way

I added an extra column

Main.xaml (11.0 KB)

8

@AAydi I can do that but problem still stays how to remove rows or create DT with booking group which have no notes.
I found a simpler solution I have uploaded a .xmal for reference.