Filter data and copy in excel

[sullivanne (Sandra)]

Hi, how can I make my robot filter out the data, if something appears after filtering it copied it and if there is nothing then it continues?

[Praveen_Mudhiraj]

can you share the sample data so easy to give the solution

@sullivanne

[Praveen_Mudhiraj]

You can try this way
i have taken the sample input like this

1. 

in else you “You can copy according to your process”

@sullivanne

[Nguyen_Van_Luong1 (Nguyễn Văn Lương (Albert Nguyễn))]

Hi @sullivanne ,
You can use filter data table

but to detail, can you share input and expect output?
regards,

[Palaniyappan (Forum Leader)]

Hi

Let’s go one by one

@sullivanne

how can I make my robot filter out the data, if something appears after filtering it copied it

There are four different ways to filter datatable
Refer this post from UiPath for more ideas

Four Ways to Filter Data Tables in UiPath Studio | UiPath

To check this

@sullivanne

and if there is nothing then it continues?

U can do it with IF activity with condition like this

DT.AsEnumerable.Any

If true it goes to then block which means it has records
If not goes to else block

Hope this help

Cheers @sullivanne