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.
Hershel
20 days agoCherelle
26 days agoMicheal
1 month agoJuan
1 month agoLynda
1 month agoEmerson
2 months agoBilly
2 months agoAliza
2 months agoMarquetta
2 months agoBlair
2 months agoIvette
2 months agoRobt
3 months agoSharika
3 months agoMoon
3 months agoPhung
4 months agoMelodie
4 months agoBrice
4 months agoNan
4 months agoChristiane
4 months agoKanisha
4 months agoMarg
5 months agoParis
5 months agoRupert
5 months agoNan
15 days ago