Creates n new formula columns, substituting references to column1 with columns from the list into the formula from the original column.
Uses the specified quoted marker theme: "standard", "hollow", "paired", "classic", or "alphanumeric".
For Color by Column, assigns colors in a chromatic sequential fashion based on the values in the highlighted column.
dt1 = Open( "$SAMPLE_DATA/Big Class.jmp" );
colnames = dt1 << Get As Matrix(); // returns all numeric columns
Show( colnames );
colnames =
[ 12 59 95,
12 61 123,
12 55 74,...]
colnums = dt1 << Get As Matrix( {4, 5} ); // returns columns four and five
Show( colnums );
colnums = [ 59 95, 61 123, 55 74, 66 145, 52 64, 60 84, 61 128, ...]
dt2 = Open( "$SAMPLE_DATA/Probe.jmp" );
colrange = dt2 << Get As Matrix( 10::22); // returns columns 10 through 22
Show( colrange );
colrange =
[ -0.08818069845438 0.711340010166168 1.85904002189636 0.396923005580902 4.50656986236572 7.86504983901978 1.53891003131866 -2.76178002357483 0.0711032971739769 5.75577020645142 -3.62023997306824 -0.971698999404907 -0.0525696985423565, ...]
The following script returns Big Class.jmp as a report and displays it and a distribution in one window.
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dtRpt = dt << Get As Report;
distRpt = V List Box(
dt << Distribution(
Continuous Distribution( Column( :weight ) ),
Nominal Distribution( Column( :age ) )
)
);
New Window( "Example", H List Box( dtRpt, distRpt ) );
"Numeric", "Ordinal", "Rowstate", "Continuous", "Ordinal", and "Nominal" get only the specified types of columns. More than one can be specified. "String" returns a list of strings rather than a list of column references.
In PopAgeGroup.jmp, the Country and Year columns are labeled. The following script returns a list of the labeled column names.
dt = Open( "$SAMPLE_DATA/PopAgeGroup.jmp" );
dt << Get Labeled Columns;
{:Country, :Year}
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Get Rows Where( :sex == "M" );
dt << Get Rows Where( :sex == "M" & :age < 15 );
dt << Get Selected Columns();
{:age, :sex, :height}
dt << Get Selected Columns( "string" );
{"age", "sex", "height"}
Determines the method for joining the tables. By Matching Columns(col1=col2, ...) matches values in col1 with col2. If they match, those values will be joined. Cartesian joins two tables using a Cartesian method, where it forms a new table consisting of all possible combinations of the rows from two original tables. JMP crosses the data in the first table with the data in the second to display all combinations of the values in each set. By Row Number joins the two tables side by side. By Matching Columns is the default value.
Optional. Prevents JMP from evaluating columns’ formulas during the creation of the new table. On by default. Use Suppress Main Table Formula Evaluation to suppress evaluation only in the main table. Use Suppress Second Table Formula Evaluation to suppress evaluation only in the secondary table.
This message can be sent to a data table object to create a link in a journal to the data table using Open(). If the data table has been saved, Open() contains the proper path and file name. However, if the data table has not yet been saved, Open() contains an incorrect file name only.
The workaround is to save the data table prior to sending the Journal Link message to the data table object. The following example produces the desired results:
dt1 = New Table( "Test",
Add Rows( 3 ),
New Column( "age", Numeric, Continuous, Format( "Best", 12 ), Set Values( [8, 9, 10] ) )
);
// Save the table before linking to a Journal.
If( Host is( Windows ),
dt1 << Save( "$DESKTOP/Test.jmp" ),
dt1 << Save( "$DESKTOP/Test.jmp" )
);
dt1 << Journal Link;
The following example creates indicator columns for the sex column. Append Column Name creates columns named sex_F and sex_M. Otherwise, the columns are named after each level (F and M). Include Missing includes missing values.
dt = Open( "$SAMPLE_DATA/Big Class.jmp" );
dt << Make Indicator Columns(
Columns( :sex ),
Append Column Name( 1 ),
Include Missing( 1 )
);
dtA = Open( "$SAMPLE_DATA/Semiconductor Capability.jmp", invisible );
nw = New Window( "Example",
H List Box(
V List Box( dtbox = dtA << New Data Box() ),
dtA << Distribution(
Continuous Distribution( Column( :NPN1 ) ),
Continuous Distribution( Column( :PNP1 ) )
)
)
);
dtbox << Set Auto Stretching( 0, 0 ) << Set Width( 800 );
Save the data table to the database named using the connection and table name specified. The Replace option replaces the existing database with the current database.
A change was made to the Set Name message so that now the new table name is returned as a string. In previous releases, Set Name returned a scriptable data table object. As a result of this change, JMP scripts might need to be updated for the desired result to be returned. For example, rewrite the following script:
dt = Open( "$SAMPLE_DATA\Big Class.jmp" ) << Set Name( "Test" );
Separate the messages so that dt represents the data table instead of “Test”:
dt = Open( "$SAMPLE_DATA\Big Class.jmp" );
dt << Set Name( "Test" );
Sets the row ID display width to the expr in pixels.
dt = Open( "$SAMPLE_DATA/Consumer Preferences.jmp" );
dt << Text To Columns(
delimiter( "," ),
columns( :Brush Delimited )
);