cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Don’t miss your chance to experience Discovery Summit Europe at our best available rate! Early bird registration through 31 Oct.
  • Graph Builder Toolbar streamlines interactive graphing. Creates shortcuts on Report and GraphBuilder Helpers toolbars. Download and install the extension.
  • JMP will suspend normal business operations for our Rest and Recharge Day on Friday, October 2, 2026.
    Regular business hours will resume on Monday, October 5, 2026.

Discussions

Solve problems, and share tips and tricks with other JMP users.
Choose Language Hide Translation Bar
Jackie_
Level VII

Extract data table tile

HI,

 

I want to extract data table tile and store in the list. I tried get data table list function and was able to store the data table names but the sting contains Data table ("Title"), I only want to store title not the data table().

 

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Big Class.jmp" );
Open( "$SAMPLE_DATA/Cars.jmp" );
list = Get Data Table List();
title = 
3 REPLIES 3
txnelson
Super User

Re: Extract data table tile

This will get you what you want

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Big Class.jmp" );
Open( "$SAMPLE_DATA/Cars.jmp" );
list = Get Data Table List();
For Each( {value, index}, list,
	list[index] = Word( 2, Char( value ), "\!"" )
);
Jim
jthi
Super User

Re: Extract data table tile

You can use <<Get Name() on the data table reference to get the table name. To get names of all datatables you can use

Names Default To Here(1);
tablenames = Get Data Table List() << Get Name();

 

jthi_0-1659071371384.png

 

-Jarmo

Re: Extract data table tile

Since the data table references are stored in a list, you can send the << Get Name message to the list and it will distribute the send to each item. The result is a new list of the names.

 

Names Default To Here( 1 );
Open( "$SAMPLE_DATA/Big Class.jmp" );
Open( "$SAMPLE_DATA/Cars.jmp" );
table = Get Data Table List();
name = table << Get Name;

Lists and matrices offer the opportunity to 'vectorize' operations by allowing functions and messages to work on the collection as a whole without the need for explicit iteration in JSL. 

Recommended Articles