Re: JSL: Selecting a Column

["Kane, Vincent D." <vincent.kane@tellabs.com>]

Kevan:

I frequently select rows based upon the conditions in a selected column

As an example

Data Table( "RMA Sort" ) << select where(:"SN Count" == "Dup");

 

 

Or, when a reference line is needed in a chart. In this example, the reference line value is row 1 of the column  Mean(% Pred)

 

Add Ref Line( :"Mean(% Pred)"[1], Solid, Black )}

Vin Kane

Principal Quality Engineer

630 798 6404

---

From: jmp-l-owner@lists.biostat.wustl.edu [mailto:jmp-l-owner@lists.biostat.wustl.edu] On Behalf Of Doyle, Kevan
Sent: Tuesday, March 11, 2008 6:05 PM
To: _JMP_List
Subject: [jmp-l] JSL: Selecting a Column

 

    Given a column reference, how does one select the column in a script? If there are several rows selected and the User clicks on one or more columns, then only the cells in the selected rows and the selected columns are selected. How is this done in a script? "dt << Select Rows({list})" and "dt << Select Where(condition)" select all columns.
    I'm currently using JMP6.0, but I also use JMP5.1 and will soon be using JMP7.0 so if there are differences, it would help to know what they are.

Thanks for the help,

Kevan
----------------------------------------------------------------------
email: Kevan.Doyle@atmel.com

============================================================
The information contained in this message may be privileged
and confidential and protected from disclosure. If the reader
of this message is not the intended recipient, or an employee
or agent responsible for delivering this message to the
intended recipient, you are hereby notified that any reproduction,
dissemination or distribution of this communication is strictly
prohibited. If you have received this communication in error,
please notify us immediately by replying to the message and
deleting it from your computer. Thank you. Tellabs
============================================================