How to use Select in more than one condition in Data table?

Help Studio
, ,
1

Here are my files for testing.
test.xlsx (9.2 KB)
Sequence9.xaml (12.1 KB)

You can use files at above for editing. As you see i tried to stamp data into a field by specific column
with simple concept for newbie understanding. And then for currently code still working well for updated.

IMPORTANT THING IS HERE
image

Now, I have a question about how can I use more than one condition if I need to do specific something such as, I need to set text ‘yes’ into a cell by where column name equal to “kate” and column lastname equal to “stela”.

Here are details.

image
image1078×617 83 KB

Thank you very for any answers and big thank for reply by example coding for easy to understand.
Rugpong

2

Here you go buddy:

Multiple AND Condition in Select Statement on DataTable - Help - UiPath Community Forum

1 Like
3

examples

filter using SELECT
dt.Select("[col1]='a' AND [col2]='a'").CopyToDataTable()

filter using select (contains)
dt.Select("[ColumnName] like '%value%'").CopyToDataTable()

1 Like
4

Thank you very much : )

5

Excellent !!! that what i want. Thank you.

6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.