Adds n columns to dt at the position indicated.
Holds off display updating to allow for quick updating of data table cells. Use End Data Update in conjunction with this command to turn display updating back on.
Begin Data Update does not affect the data refresh due to some other table manipulations. For example, when you delete or add columns, the data table is updated and then the data update begins.
Creates n new formula columns, substituting references to column1 with columns from the list into the formula from the original column.
Color Theme("theme")
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.
Creates a new table ("name") from the rows of dt and dt2.
Arguments for Mode() include Select(), Show(), and Include(). They are all Boolean. Select defaults to true(1), and Show and Include default to false (0).
Arguments for Add Filter() include Columns(), and Where(). Columns() takes one or more column names separated by commas. You can add one or more WHERE clauses to define the filter.
dt<<Data View(<"options">)
Deletes column(s) from the data table dt. Specify which column or columns to delete. Without an argument, deletes the selected columns, if any. Delete Column is a synonym.
Resumes display updating after a Begin Data Update message. These commands are used for quick updates of the data table when many changes have to be made. Speed is gained by turning off display updating.
Toggles selected rows in dt from excluded to unexcluded or vice versa.
Returns the values from all columns of dt in a matrix. Character columns are numbered according to the levels, starting at 1.
Returns values from the numeric columns of dt in a matrix. The default output is all numeric columns.
dt1 = Open( "$SAMPLE_DATA/Big" );
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/" );
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 as a report and displays it and a distribution in one window.
dt = Open( "$SAMPLE_DATA/Big" );
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 ) );
Returns a list of column names in a data table. The "arguments" restrict the names retrieved as follows:
"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, the Country and Year columns are labeled. The following script returns a list of the labeled column names.
dt = Open( "$SAMPLE_DATA/" );
dt << Get Labeled Columns;
{:Country, :Year}
Returns the name of the table.
Returns the script in the property name.
dt = Open( "$SAMPLE_DATA/Big" );
dt << Get Rows Where( :sex == "M" );
dt << Get Rows Where( :sex == "M" & :age < 15 );
Returns a list of selected columns as column references. Include the "string" argument to return the selected columns in a string.
dt << Get Selected Columns();
{:age, :sex, :height}
dt << Get Selected Columns( "string" );
{"age", "sex", "height"}
Toggles selected rows in dt from hidden to unhidden or vice versa.
Combines data tables dt and table side to side. For details about joining tables, see Join Data Tables in the Using JMP book.
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/" ),
	dt1 << Save( "$DESKTOP/" )
dt1 << Journal Link;
Toggles selected rows in dt from labeled to unlabeled or vice versa.
dt<<Make Indicator Columns( <Append Column Name(Boolean)>, <Include Missing(Boolean)>);
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" );
dt << Make Indicator Columns(
	Columns( :sex ),
	Append Column Name( 1 ),
	Include Missing( 1 )
Assigns marker n to the selected rows.
dt<<Move Selected Columns("To First"|"To Last"|After(col))
dt<<Move Rows("At Start"|"At End"|After(n))
Adds a new column named "name" after the last column in dt. Can also be used as a function: New Column("name", attributes).
dtA = Open( "$SAMPLE_DATA/Semiconductor", 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 );
Creates a new table property using the specified name that stores the specified script.
Use New Script() or Set Property() rather than the deprecated New Property() and New Table Property().
dt<<Print Window(<"Show Dialog">)
Prints the window. If the optional argument "Show Dialog" is specified, the print window is displayed. Otherwise, the window is printed to the default printer using the current settings, and no print window is displayed.
Reorders columns in dt, row state first, then character, then numeric.
Reorders columns in dt to continuous, then ordinal, then nominal.
Reorders columns in dt to alphanumeric order by name.
Reverses columns in dt from current order.
Finds the table property name and runs it as a JSL script.
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.
Randomly selects the given percentage p of the rows in the data table, or the number of rows n.
Selects the rows in dt where the condition evaluates as true.
Gives a "name" to the table. The new data table name is returned as a string.
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" ) << Set Name( "Test" );
Separate the messages so that dt represents the data table instead of “Test”:
dt = Open( "$SAMPLE_DATA\Big" );
dt << Set Name( "Test" );
dt<<Sort(By(columns), order("Descending" or "Ascending"), Output Table Name("name"))
Creates a new table ("name") by rearranging the rows of dt according to the values of one or more columns.
Un-stacks multiple rows for each Split column into multiple columns as identified by the Split by column. The Split and Split by arguments are required.
Creates a new table ("name") by combining the values from several columns in dt into one column newcol.
Creates a new table ("name") from the rows that you specify in dt.
Creates a new table of summary statistics for the col that you specify, according to groups and subgroups.
dt = Open( "$SAMPLE_DATA/Consumer" );
dt << Text To Columns(
	delimiter( "," ),
	columns( :Brush Delimited )
Creates a new table ("name") from the rows and columns that you specify.

Help created on 9/19/2017