Add filter to excel table in UiPath

0 votes

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

May 16, 2018 in RPA by Atul
• 5,490 points
1,011 views

1 answer to this question.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
0 votes
If you use *my value as the search / filter pattern, then it would 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 the filter, have your filter text followed by the wildcard, like - my value*.

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 search for text beginning with *my value.
answered May 16, 2018 by wrecker
• 3,090 points

Related Questions In RPA

0 votes
1 answer

Pivot table in excel using UIpath

down vo I'd suggest you are going to ...READ MORE

answered May 28, 2018 in RPA by wrecker
• 3,090 points
540 views
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
1,440 views
0 votes
1 answer

Can I create dictionary in UiPath studio and add items to it?

Hey @Rumani, you can definitely create dictionary ...READ MORE

answered Mar 13 in RPA by Abha
• 8,200 points
446 views
0 votes
1 answer

Unable to add custom library in UiPath Studio.

Hi @Neetu, if you have a custom ...READ MORE

answered Mar 25 in RPA by Anvi
• 7,160 points
52 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
216 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
829 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
289 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,140 points
406 views
0 votes
1 answer

How to add filter to excel table in UI Path?

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

answered Aug 6, 2018 in RPA by wrecker
• 3,090 points
284 views
0 votes
4 answers

Pivot table in excel using UIpath

You can use Create Pivot Table activity ...READ MORE

answered Feb 25 in RPA by Anvi
• 7,160 points
613 views

© 2018 Brain4ce Education Solutions Pvt. Ltd. All rights Reserved.
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.