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
2 months agoCherelle
2 months agoMicheal
3 months agoJuan
3 months agoLynda
3 months agoEmerson
3 months agoBilly
3 months agoAliza
3 months agoMarquetta
4 months agoBlair
4 months agoIvette
4 months agoRobt
5 months agoSharika
5 months agoMoon
5 months agoPhung
5 months agoMelodie
5 months agoBrice
5 months agoNan
6 months agoChristiane
6 months agoKanisha
6 months agoMarg
6 months agoParis
6 months agoRupert
7 months agoOren
11 days agoAhmad
16 days agoNan
2 months ago