How to filter data

Help Activities
, ,
1

I want to filter the following data using UiPath.
No.|Name|vehicle|
1|Jaka|Have|
2|Irul|Have|
3|Adel||
4|Luke|Have|
I want to delete the rows in the “vehicle” column that contain values ​​and retain the data rows that in the “vehicle” column do not have values. but when the data is like below,
No.|Name|vehicle|
1|Jaka|Have|
2|Irul|Have|
3|Adel|Have|
4|Luke|Have|
Why is the header from the previous filter also deleted? How do I ensure that when I filter the header it doesn’t get deleted? Please help :pray:

2

Hi @wsinten

image
image1589×793 69.7 KB

image
image1365×758 48.5 KB

Hope it helps!!

3

Hello @wsinten
Try this

  1. read the excel and assign the data with the data table variable.
  2. use the Filter data table activity to filter the data
    Use filter Option to Keep properties with Operation is Empty in vehicle Column
    image
    image740×460 15.2 KB
4

Thank you sir for helping me :pray:

1 Like
5

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