Free Preparation Discussions
MENU
UiPath-ARDv1 Exam - Topic 4 Question 119 Discussion
Topic #: 4
A developer wants to filter the following datatable to get all rows with people from Canada younger than 50 years old who provided their email address. Which expression provides the required results?
To filter a datatable using .Select method, follow the rules:
1. Place column name in square brackets
e.g. [Country]
2. Next, place a comparison sign (=, <=, >=, or <>)
e.g. [Country] =
3. Place all string values in a single quotation ' '
e.g. [Country] = 'Canada'
4. Join all required conditions using keywords like AND, OR
e.g. [Country] = 'Canada' AND [Age] < 50 AND [Email] <> ''
5. Surround all conditions in double quotes ' ' and place the final string in brackets after .Select
e.g. DataTable.Select('[Country] = 'Canada' AND [Age] < 50 AND [Email] <> ''')
UiPath forum
Exam Topic:Describe how to initialize variables such as lists and datatables, and how to filter datatables.
Emerson
1 day agoBilly
6 days agoAliza
11 days agoMarquetta
17 days agoBlair
22 days agoIvette
27 days agoRobt
2 months agoSharika
2 months agoMoon
2 months agoPhung
2 months agoMelodie
2 months agoBrice
2 months agoNan
3 months agoChristiane
3 months agoKanisha
3 months agoMarg
3 months agoParis
3 months agoRupert
3 months ago