cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-14154%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%ED%99%95%EC%9E%A5%20%EC%84%A0%ED%83%9D%20%EC%9C%84%EC%B9%98%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-14154%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%26lt%3Bmeta%20http-equiv%3D%22Content-Type%22%20content%3D%22text%2Fhtml%3B%20charset%3DUTF-8%22%20%2F%26gt%3B%3CP%3E%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%20%EA%B0%80%EC%9D%B4%EB%93%9C%EC%97%90%EC%84%9C%20%EC%9D%B4%20%EB%AC%B8%EC%A0%9C%EB%A5%BC%20%ED%95%B4%EA%B2%B0%ED%95%A0%20%EC%88%98%20%EC%9E%88%EC%8A%B5%EB%8B%88%EA%B9%8C%3F%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%2F%2F%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%20%EA%B0%80%EC%9D%B4%EB%93%9C%20336%ED%8E%98%EC%9D%B4%EC%A7%80%3C%2FP%3E%3CP%3Edt%20%3D%20Open(%20%22%24SAMPLE_DATA%5CBig%20Class.jmp%22%20)%3B%3C%2FP%3E%3CP%3Edt%20%26lt%3B%26lt%3B%20Select%20Where(%20age%20%26lt%3B%2015%20%26amp%3B%20sex%20%3D%3D%20%22F%22%20)%3B%3C%2FP%3E%3CP%3E%2F%2F%EB%98%90%EB%8A%94%3C%2FP%3E%3CP%3Edt%20%26lt%3B%26lt%3B%20Select%20Where(%20%EB%82%98%EC%9D%B4%20%3D%3D%2014%20)%3B%3C%2FP%3E%3CP%3Edt%20%26lt%3B%26lt%3B%20%ED%99%95%EC%9E%A5%20%EC%84%A0%ED%83%9D%20Where(%20sex%20%3D%3D%20%22F%22%20)%3B%20%2F%2F%EC%95%84%EB%AC%B4%EA%B2%83%EB%8F%84%20%ED%95%98%EC%A7%80%20%EC%95%8A%EB%8A%94%EB%8B%A4%3C%2FP%3E%3CP%3E%2F%2F%20%EA%B0%80%EC%9D%B4%EB%93%9C%EC%97%90%EB%8A%94%20%EC%97%86%EC%A7%80%EB%A7%8C%20%EC%95%84%EB%9E%98%EC%97%90%EC%84%9C%20%EC%9E%91%EB%8F%99%ED%95%A9%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CP%3E%EB%8C%80%EA%B8%B0(10)%3B%3C%2FP%3E%3CP%3Edt%20%26lt%3B%26lt%3B%20Select%20Where(%20sex%20%3D%3D%20%22F%22%2C%20%ED%98%84%EC%9E%AC%20%EC%84%A0%ED%83%9D%20%ED%95%AD%EB%AA%A9(%22extend%22))%3B%20%2F%2F%EC%84%A0%ED%83%9D%20%ED%99%95%EC%9E%A5%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-14155%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3ERe%3A%20%ED%99%95%EC%9E%A5%20%EC%84%A0%ED%83%9D%20%EC%9C%84%EC%B9%98%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-14155%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%EB%8B%A4%EC%9D%8C%EC%9D%80%20JMP%2012.1%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%20%EA%B0%80%EC%9D%B4%EB%93%9C%EC%9D%98%20340%ED%8E%98%EC%9D%B4%EC%A7%80%EC%97%90%20%EC%9E%88%EC%9C%BC%EB%A9%B0%20%ED%98%84%EC%9E%AC%20%EC%98%A8%EB%9D%BC%EC%9D%B8%20%EC%84%A4%EB%AA%85%EC%84%9C%EC%97%90%EB%8F%84%20%ED%8F%AC%ED%95%A8%EB%90%98%EC%96%B4%20%EC%9E%88%EC%8A%B5%EB%8B%88%EB%8B%A4.%3C%2FP%3E%3CPRE%20__jive_macro_name%3D%22quote%22%20class%3D%22jive_text_macro%20jive_macro_quote%22%3E%3CBR%20%2F%3E%3CP%3ETo%20select%20a%20row%20without%20deselecting%20a%20previously%20selected%20row%2C%20combine%20%26lt%3B%26lt%3B%20Select%20Where%20with%3C%2FP%3E%3CBR%20%2F%3E%3CP%3E%26lt%3B%26lt%3B%20Select%20Where%20and%20the%20current%20selection(%22extend%22)%20argument.%20This%20is%20an%20alternative%20to%3C%2FP%3E%3CBR%20%2F%3E%3CP%3Eusing%20an%20OR%20statement.%3C%2FP%3E%3CBR%20%2F%3E%3CP%3Edt%20%26lt%3B%26lt%3B%20Select%20Where(%20age%20%3D%3D%2014%20)%3B%3C%2FP%3E%3CBR%20%2F%3E%3CP%3Edt%20%26lt%3B%26lt%3B%20Select%20Where(%20sex%20%3D%3D%20%22F%22%2C%20current%20selection(%22extend%22))%3B%3C%2FP%3E%3CBR%20%2F%3E%3C%2FPRE%3E%3CP%3E%3C%2FP%3E%3CP%3E%EB%8F%84%EC%9B%80%EC%9D%B4%20%EB%90%98%EA%B8%B8%20%EB%B0%94%EB%9E%8D%EB%8B%88%EB%8B%A4!%3C%2FP%3E%3CP%3E%3C%2FP%3E%3CP%3E%EC%9B%AC%EB%94%94%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar
msharp
Super User (Alumni)

Extend Select Where

Can we get this fixed in the Scripting Guide?

//Scripting Guide page 336

dt = Open( "$SAMPLE_DATA\Big Class.jmp" );

dt << Select Where( age < 15 & sex == "F" );

//or

dt << Select Where( age == 14 );

dt << Extend Select Where( sex == "F" ); //does nothing

//Not in guide, but below works

wait(10);

dt << Select Where( sex == "F", Current Selection ("extend")); //extends selection

1 REPLY 1

Re: Extend Select Where

The following is from page 340 in the JMP 12.1 Scripting Guide and is also included in the current online documentation:


To select a row without deselecting a previously selected row, combine << Select Where with


<< Select Where and the current selection("extend") argument. This is an alternative to


using an OR statement.


dt << Select Where( age == 14 );


dt << Select Where( sex == "F", current selection("extend"));


Hope that helps!

Wendy

Wendy

Recommended Articles