Filter

Help
1

Hi All,

I am trying to automate excel sheet with some condition by using filter option, but it is not working.Book1.xlsx (12.6 KB) .

i am trying to automate only those names who is working on department Automation

2

Hey @Rakesh_Tiwari

Just Do Below Steps:

  1. Read Excel File by using Excel Application Scope Activity.
  2. Use Read Range to Read your Desired Sheet Data and Create an output Variable by Hitting Ctrl+k with your desired Name suppose DT.
  3. Then use Filterd Data Table Activity" to filter datatable.
    image

Regards…!!
Aksh

3

Filter
Filter1920Ă—1080 115 KB

i tried still getting this error.

pls check once the error, where i am doing wrong.

4

Hey @Rakesh_Tiwari

Try This: - FilterSample.xaml (7.3 KB)

Regards…!!
Aksh

1 Like
5

Thanks for your reply,

yes, it’s working, but can u pls tell me where i was doing wrong. coz i am new in UiPath.

6

Hey @Rakesh_Tiwari

Well have to check your file to say anything but from a quick inspection it look like to me there is error with your data-table variable definition

Regards…!!
AKsh

7

Thanks for writing,

i keep the variable definition same as you kept, but still not working.

Anyways thanks

Regards
Rakesh

8

Hey @Rakesh_Tiwari

can you share your xaml? so i can have a quick look?

Regards…!!
Aksh

9

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