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

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

razmah — Mon, 27 Jul 2015 16:53:22 GMT

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?

Dan_Obermiller — Mon, 27 Jul 2015 17:04:32 GMT

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.

razmah — Mon, 27 Jul 2015 17:11:09 GMT

Thanks a lot.