How to add filter to excel table in UI Path?

0 votes

I have an excel file with a table named 'Table1' in it. I have to perform 'Filter Table' activity in UiPath with the condition "column1 begins with '*my column'". But when I specify the value like this, the column is filtered for 'ends with' operation. 

Aug 6, 2018 in RPA by Vardy
• 2,280 points
328 views

1 answer to this question.

0 votes
If you use *my value as the search / filter pattern, then it'd mean, anything in the beginning and must have my value in the end. So, it is being interpreted correctly as Ends With. If you want to have a Begins With filter, you should have your filter text followed by the wildcard, like - my value*.

Further, if you want to include wildcard as a literal in the search pattern, you'd need to escape that by enclosing it in brackets like [*]my value* - this'd search for text beginning with *my value.
answered Aug 6, 2018 by wrecker
• 3,090 points

Related Questions In RPA

0 votes
3 answers

How to find the sum of 2 columns of an excel and display it in a 3rd column using UIPATH?

1.  Excel Application Scope (Activity) : In ...READ MORE

answered Jun 9 in RPA by anonymous
• 140 points
2,091 views
0 votes
1 answer

how can i add collection data to csv in blue prism?

I've done this, but I dont have ...READ MORE

answered Oct 5, 2018 in RPA by Priyaj
• 56,160 points
1,350 views
0 votes
1 answer

In Blue Prism how to split excel column data into TWO columns

This is how I am doing it. Dim ...READ MORE

answered Oct 15, 2018 in RPA by Priyaj
• 56,160 points
1,167 views
0 votes
1 answer

How to scrape data using Get Text from UI Automation tools in UiPath?

Hi Roshni, scraping any text from a web page ...READ MORE

answered Mar 20 in RPA by Pratibha
• 2,740 points
116 views
0 votes
1 answer

Automation in Uipath

you can use the Database package for connecting  ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,090 points
254 views
0 votes
1 answer

UiPath vs Workfusion

in WorkFusion, you can create a script ...READ MORE

answered Apr 17, 2018 in RPA by wrecker
• 3,090 points
900 views
0 votes
1 answer

Surface automation in rpa?

Surface automation is a visual automation that is done using ...READ MORE

answered Apr 20, 2018 in RPA by wrecker
• 3,090 points
334 views
+1 vote
2 answers

Azure Cognitive services with RPA

Automation anywhere has support for making SOAP ...READ MORE

answered Aug 7, 2018 in RPA by Priyaj
• 56,160 points
436 views
0 votes
1 answer

Add filter to excel table in UiPath

If you use *my value as the ...READ MORE

answered May 16, 2018 in RPA by wrecker
• 3,090 points
1,160 views
0 votes
1 answer

How to assign a data in a variable in to excel file?

System -> File -> Workbook -> Append ...READ MORE

answered May 22, 2018 in RPA by wrecker
• 3,090 points
63 views