cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
New to using JMP? Hit the ground running with the Early User Edition of Discovery Summit. Register now, free of charge.
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
%3CLINGO-SUB%20id%3D%22lingo-sub-749359%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%EC%97%B4%EC%9D%98%20%ED%82%A4%EC%9B%8C%EB%93%9C%EB%A1%9C%20%ED%95%98%EC%9C%84%20%EC%A7%91%ED%95%A9%20%ED%96%89%EC%9D%B4%20%EC%9E%90%EB%8F%99%EC%9C%BC%EB%A1%9C%20%EC%84%A0%ED%83%9D%EB%90%A9%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749359%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%EC%83%98%ED%94%8C%20ID%2C%20%ED%85%8C%EC%8A%A4%ED%8A%B8%2C%20%EA%B0%9C%EC%88%98%20%EB%B0%8F%20%EC%9D%BC%EB%B6%80%20%EB%B2%94%EC%A3%BC%ED%98%95%20%EC%A0%95%EB%B3%B4%EA%B0%80%20%ED%8F%AC%ED%95%A8%EB%90%9C%20%ED%81%B0%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EC%9D%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%ED%85%8C%EC%8A%A4%ED%8A%B8%20%EC%97%B4%EC%9D%80%20%EC%B9%B4%EC%9A%B4%ED%8A%B8%EA%B0%80%20%EC%B0%B8%EC%A1%B0%ED%95%98%EB%8A%94%20%ED%85%8C%EC%8A%A4%ED%8A%B8%EC%99%80%20%EA%B7%B8%EA%B2%83%EC%9D%B4%20%EC%96%91%EC%84%B1%20%EB%AA%A8%EC%A7%91%EB%8B%A8%EC%9D%B8%EC%A7%80%20%EC%9D%8C%EC%84%B1%20%EB%AA%A8%EC%A7%91%EB%8B%A8%EC%9D%B8%EC%A7%80%20%EC%97%AC%EB%B6%80%EB%A5%BC%20%EC%8B%9D%EB%B3%84%ED%95%A9%EB%8B%88%EB%8B%A4.%20%EC%98%88%EB%A5%BC%20%EB%93%A4%EC%96%B4%20%221%EA%B0%9C%20%EC%96%91%EC%84%B1%20%ED%85%8C%EC%8A%A4%ED%8A%B8%22%2C%20%221%EA%B0%9C%20%EC%9D%8C%EC%84%B1%20%ED%85%8C%EC%8A%A4%ED%8A%B8%22%20%EB%93%B1%EC%9D%80%20%EB%AC%BC%EB%A1%A0%20%22%EC%A0%84%EC%B2%B4%20%ED%85%8C%EC%8A%A4%ED%8A%B8%22%EC%99%80%20%EA%B0%99%EC%9D%80%20%EC%9D%BC%EB%B6%80%20%ED%96%89%EB%8F%84%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%20%EC%9D%B4%EB%8A%94%20%EA%B0%81%20%EC%83%98%ED%94%8C%EB%A7%88%EB%8B%A4%20%EB%B0%98%EB%B3%B5%EB%90%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%EC%95%9E%EC%97%90%20%EC%9E%88%EB%8A%94%20%ED%85%8C%EC%8A%A4%ED%8A%B8%20ID%EC%97%90%20%EA%B4%80%EA%B3%84%EC%97%86%EC%9D%B4%20%EC%97%B4%EC%97%90%20%22%EC%96%91%EC%88%98%22%EA%B0%80%20%EC%9E%88%EB%8A%94%20%EB%AA%A8%EB%93%A0%20%ED%96%89%EC%9D%84%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EC%84%A0%ED%83%9D%ED%95%98%EC%97%AC%20%EC%83%88%20%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%85%8C%EC%9D%B4%EB%B8%94%EB%A1%9C%20%ED%95%98%EC%9C%84%20%EC%A7%91%ED%95%A9%EC%9D%84%20%EB%A7%8C%EB%93%A4%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EA%B9%8C%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-749359%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CLINGO-LABEL%3E%EB%8D%B0%EC%9D%B4%ED%84%B0%20%ED%98%BC%ED%95%A9%20%EB%B0%8F%20%EC%A0%95%EB%A6%AC%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3E%EC%9C%88%EB%8F%84%EC%9A%B0%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-749370%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERe%3A%20%EC%97%B4%EC%9D%98%20%ED%82%A4%EC%9B%8C%EB%93%9C%EB%A1%9C%20%ED%95%98%EC%9C%84%20%EC%A7%91%ED%95%A9%20%ED%96%89%EC%9D%B4%20%EC%9E%90%EB%8F%99%EC%9C%BC%EB%A1%9C%20%EC%84%A0%ED%83%9D%EB%90%A9%EB%8B%88%EA%B9%8C%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749370%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3E%ED%96%89%20%EC%84%A0%ED%83%9D%20%26gt%3B%20%ED%96%89%20%EC%84%A0%ED%83%9D...%3C%2FP%3E%0A%3CP%3E%20%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
Mcc99
Level I

Subset rows automatically selected for by key word in column?

I have a tall data table with sample ID, test, count, and some categorical info. The test column identifies which test the count refers to and whether it's a positive or negative population. For example "Test one positive", "test one negative", etc., as well as some rows such as "total tests". These repeat for each sample.

How would I select all the rows with a "positive" in the column regardless of which test ID is before it, so I can then subset them into a new data table?  

1 ACCEPTED SOLUTION

Accepted Solutions

Re: Subset rows automatically selected for by key word in column?

Select Rows > Row Selection > Select Where...

See Row Selection examples.

View solution in original post

1 REPLY 1

Re: Subset rows automatically selected for by key word in column?

Select Rows > Row Selection > Select Where...

See Row Selection examples.