Publication date: 07/08/2024

Create a New Data Table

Using JSL, you can create a new data table, or create a new data table and store its reference in a global variable. In either case, specify the table name as an argument.

New Table( "My Table" );

or

dt = New Table( "My Table" );

The following sections describe the optional arguments for the New Table() function.

Private, Invisible, and Visible

The optional visibility argument specifies whether the new data table is shown. visibility( "invisible" ) hides the data table from view; it appears only in the JMP Home Window and the Window menu. visibility( "private" ) avoids opening the data table. visibility( "visible" ) shows the data table. "visible" is the default value.

New Table( "My Table", visibility( "private" ) );

A private data table enables you to avoid exposing the table to general use. Sometimes a script creates a private data table to store private data generated by a process. It is not for saving memory.

When you do not need a view of the data, or when you do not need to interact with the data, use an invisible data table.

Notes:

The advantages of using private data tables is based on the size of the data in the table. If the data table has only five columns and 20 rows, the savings for a private data table is substantial. However, for a table with 100 columns and 1,000,000 rows, the overhead of the actual window is small in comparison to the actual data.

Private tables are not counted when N Table() returns the number of open data tables.

Private tables cannot be made current with Current Data Table().

Actions

An optional argument that can define the new table. For example, the following script creates a new data table named Little Class. It adds three rows and two named columns as well as entering values for each cell in the table:

dt = New Table( "Little Class",
	Add Rows( 3 ),
	New Column( "name",
		Character,
		"Nominal",
		Set Values( {"KATIE", "LOUISE", "JANE"} )
	),
	New Column( "height",
		"Continuous",
		Set Values( [59, 61, 55] )
	)
);
Want more information? Have questions? Get answers in the JMP User Community (community.jmp.com).