Filter Table in excel data tables


#21

Hi

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

When I try to use it, following this page explanation:

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


#30