https://community.jmp.com/t5/Discussions/Subset-rows-automatically-selected-for-by-key-word-in-column/m-p/749359#M92982 <P>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.</P><P>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?&nbsp;&nbsp;</P> Wed, 24 Apr 2024 14:37:32 GMT Mcc99 2024-04-24T14:37:32Z https://community.jmp.com/t5/Discussions/Subset-rows-automatically-selected-for-by-key-word-in-column/m-p/749359#M92982 <P>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.</P><P>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?&nbsp;&nbsp;</P> Wed, 24 Apr 2024 14:37:32 GMT https://community.jmp.com/t5/Discussions/Subset-rows-automatically-selected-for-by-key-word-in-column/m-p/749359#M92982 Mcc99 2024-04-24T14:37:32Z https://community.jmp.com/t5/Discussions/Subset-rows-automatically-selected-for-by-key-word-in-column/m-p/749370#M92983 <P>Select Rows &gt; Row Selection &gt; Select Where...</P> <P>See <A href="https://www.jmp.com/support/help/en/18.0/#page/jmp/select-deselect-and-find-values-in-a-data-table.shtml" target="_self">Row Selection</A> examples.</P> Wed, 24 Apr 2024 14:44:05 GMT https://community.jmp.com/t5/Discussions/Subset-rows-automatically-selected-for-by-key-word-in-column/m-p/749370#M92983 Mark_Bailey 2024-04-24T14:44:05Z