cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
razmah
Level II

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

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

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

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

View solution in original post

2 REPLIES 2

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

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
Level II

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

Thanks a lot.

Recommended Articles