Multiple AND Condition in Select Statement on DataTable

Hi Friends,
I am able to use select query for single conditions like:-
dt_questionsData.Select(“[ID]=‘6’ AND [Number]=‘161’”).CopyToDataTable
but I want to apply multiple and Conditions with where clause on datatable.

I try like this:-
dt_questionsData.Select(“[ID]=‘6’ AND [ID]=‘7’ AND [ID]=‘8’ WHERE [Application ID]=‘161’”).CopyToDataTable

then i got error like :- Syntax missing after WHERE operator
Please help me over this.

1 Like

Hi @Rup_1

Instead of Where you can use and operator



1 Like

Hi @ AshwinS2

I tried but i got error like “can not find column [6]”

1 Like

Note that filter inside already works as a where clause. Per your scenario, you want to filter Application ID Column first before filtering the ID Column. Basically, you will do two select function to achieve your desired results.

dt_questionsData.Select(“[Application ID]=‘161’”).CopyToDataTable.Select(“[ID]=‘6’ AND [ID]=‘7’ AND [ID]=‘8’”).CopyToDataTable

1 Like

If you feel no so sure about your codes you can use the filter data table activities @Rup_1

cheers :smiley:

Happy learning :smiley:


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