An example that I have run successfully.
// Columns to be deleted 6 : 8
cc=dt1<<Get Column Names;
for(i=6,i<=8,i++, cc[i]<<Set Selected(1););
// Columns to be deleted 13 : 14
for(i=12,i<=14,i++, cc[i]<<Set Selected(1););
// Columns to be deleted 19 : 26
for(i=18,i<=26,i++, cc[i]<<Set Selected(1););
dd = dt1 << Get Selected Columns;
dt1 << Delete Columns(dd);
Bernard Silke
> 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
> ============================================================
>
|