cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
%3CLINGO-SUB%20id%3D%22lingo-sub-749359%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3ERighe%20del%20sottoinsieme%20selezionate%20automaticamente%20per%20parola%20chiave%20nella%20colonna%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749359%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3EHo%20una%20tabella%20dati%20alta%20con%20ID%20campione%2C%20test%2C%20conteggio%20e%20alcune%20informazioni%20categoriche.%20La%20colonna%20test%20identifica%20a%20quale%20test%20si%20riferisce%20il%20conteggio%20e%20se%20si%20tratta%20di%20una%20popolazione%20positiva%20o%20negativa.%20Ad%20esempio%20%22Test%20uno%20positivo%22%2C%20%22Test%20uno%20negativo%22%2C%20ecc.%2C%20oltre%20ad%20alcune%20righe%20come%20%22totale%20test%22.%20Questi%20si%20ripetono%20per%20ogni%20campione.%3C%2FP%3E%3CP%3ECome%20selezionerei%20tutte%20le%20righe%20con%20un%20%22positivo%22%20nella%20colonna%20indipendentemente%20dall'ID%20del%20test%20che%20lo%20precede%2C%20in%20modo%20da%20poterle%20quindi%20sottoimpostare%20in%20una%20nuova%20tabella%20dati%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%3ECombinazione%20e%20pulizia%20dei%20dati%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Efinestre%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%3ERi%3A%20Righe%20del%20sottoinsieme%20selezionate%20automaticamente%20dalla%20parola%20chiave%20nella%20colonna%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-749370%22%20slang%3D%22en-US%22%20mode%3D%22CREATE%22%3E%3CP%3ESeleziona%20righe%20%26gt%3B%20Seleziona%20righe%20dove...%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.