Subscribe Bookmark RSS Feed

Newbie question: How can I select multiple rows with different values in one column?

razmah

Community Trekker

Joined:

Jul 20, 2015

this is my data table:

A     B

9     1300

10    1300

11    1300

12    500

13    900

14    1300

15    1300

16    1300

And I have three variables: M=10, N=11, and P=13

I want to select rows where A=M and A=N, and A=P.

I wrote this line, but it  only selects A=M.

dt << Select Where (A==M& A==N & A==P) ;

do you have any suggestions?

1 ACCEPTED SOLUTION

Accepted Solutions
Dan_Obermiller

Joined:

Apr 3, 2013

Solution

A can't be 9 and 11 and 13 all at the same time. I think you want an OR operator instead of an AND operator.

dt << Select Where (A==M | A==N | A==P);

should do the trick.

Dan Obermiller
2 REPLIES
Dan_Obermiller

Joined:

Apr 3, 2013

Solution

A can't be 9 and 11 and 13 all at the same time. I think you want an OR operator instead of an AND operator.

dt << Select Where (A==M | A==N | A==P);

should do the trick.

Dan Obermiller
razmah

Community Trekker

Joined:

Jul 20, 2015

Thanks a lot.