Filter Table in excel data tables

Help
21

Hi

Has anyone been able to work with the “Filter Data Table” activity?

When I try to use it, following this page explanation:
https://activities.uipath.com/docs/filter-data-table

The activity still gives errors.

Please have a look at the workfile. (Create a folder call “Data” and put the Excel into that folder)
TestData.xlsx (8.1 KB)
data table text.xaml (9.7 KB)

BR
Helliton

22

This is working as expected, you just have to be careful about DataTypes while filtering.

Have a look at attached sample and let me know you if this helps

Main.xaml (10.6 KB)

23

Cool! It works!

Thanks a lot for the help!

24

Hi Prankurjoshi,

I did as per your sequence from main.xaml and i am trying to load the filtered output to an excel but for some reason i am stuck with an error .

Can you please have a look and let me know where i am going wrong ?
Attachment is below

Thanks
VishnuWorking with filter.xaml (10.2 KB)
sampleout.xlsx (7.9 KB)

25

Never mind…I recreated again following your xaml and it worked.

THanks
Vishnu

26

Hi Aksh,

In response to above quoted text, I have a use case.
I have a Table in which the column has text in red font and black font. I usually filter the Table using “Sort by color - RED” in Excel. How would this activity take place in UiPath? What would I put in ‘Filter Options’ in the Filter table activity?

Thanks,
Kaustubh

27

@aksh1yadav From where did you get the table name as you mentioned “Table3” in table name field in filter activity.

28

Could you please tell. what is “TABLE” here??

29

Hey @Manchikanti_Abhinay and @khan

TableName - The name of the table that you want to filter.

See the attached screenshot for more clarity. if more then 1 table just click on table and get name.

image

Regards…!!
Aksh

2 Likes