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.
  • Image to Table JMP extension imports single or batch images as data tables. Useful to extract curves from pictures or convert image data to curve data to use in analyses like Functional Data Explorer. Download and install the extension.

Discussions

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

How to prevent a data table window from appearing when creating it via script in JMP?

Hi everyone,

I have a JMP script that merges multiple tables into a single output table (see code snippet below).
Even though I’m trying to keep it hidden using:

 

Data Table("Combined_Output_Table") << Invisible(1);

 

the data table window still pops up briefly when it’s created (especially when using Concatenate or Join).

Is there a reliable way to keep the table from opening at all while the script runs?

I’ve tried:

  • Adding Invisible after creation

  • Using Show Window(0) or Hide Window()

  • Assigning it to a variable and setting invisible immediately

None seem to fully prevent the window from opening momentarily.

Sample Code- 

//### Create combined output table
calcVersion = "Combined_Output_Table"; // Name of the final output table

nTables = N Items( tableNameList );

// Combine multiple batch tables into one
If(
	nTables == 1,
	Data Table( OpenTableNames[1] ) << Set Name( calcVersion ),
	FirstTable = Remove From( tableNameList );
	FirstTable << Concatenate(
		tableNameList,
		Output Table Name( calcVersion )
	);
	
	// Close intermediate tables
	For( i = 1, i <= nTables, i++,
		Close( Data Table( OpenTableNames[i] ), NoSave )
	);
);

//### Attempt to hide the window
Data Table( calcVersion ) << Invisible( 1 );
1 ACCEPTED SOLUTION

Accepted Solutions
hogi
Level XIII

Re: How to prevent a data table window from appearing when creating it via script in JMP?


@zetaVagabond1 wrote:

I’ve tried:

  • Adding Invisible after creation



add invisible during creation : )

 

open(filename, invisible)

 

 

even better: use private - this will speed up the data curation process.

Many Platforms allow you to add these settings. 

Data Table( "Big Class Families" ) << Subset( All rows, Selected columns only( 0 ) , invisible);
myDT << Concatenate(tableNameList, Invisible);

It hurts that other platforms don't provide the setting - like Multi File Import!!
Private tables with Multiple File Import function

please vote to get this issue fixed:
Private option for Import Multiple Files 
 

 

View solution in original post

3 REPLIES 3
hogi
Level XIII

Re: How to prevent a data table window from appearing when creating it via script in JMP?


@zetaVagabond1 wrote:

I’ve tried:

  • Adding Invisible after creation



add invisible during creation : )

 

open(filename, invisible)

 

 

even better: use private - this will speed up the data curation process.

Many Platforms allow you to add these settings. 

Data Table( "Big Class Families" ) << Subset( All rows, Selected columns only( 0 ) , invisible);
myDT << Concatenate(tableNameList, Invisible);

It hurts that other platforms don't provide the setting - like Multi File Import!!
Private tables with Multiple File Import function

please vote to get this issue fixed:
Private option for Import Multiple Files 
 

 

hogi
Level XIII

Re: How to prevent a data table window from appearing when creating it via script in JMP?

Instead of

// Combine multiple batch tables into one
If(
	nTables == 1,
	Data Table( OpenTableNames[1] ) << Set Name( calcVersion ),
	FirstTable = Remove From( tableNameList );
	FirstTable << Concatenate(
		tableNameList,
		Output Table Name( calcVersion )
	);
	
	// Close intermediate tables
	For( i = 1, i <= nTables, i++,
		Close( Data Table( OpenTableNames[i] ), NoSave )
	);
);

you could write

myDT= new table(calcversion,invisible);
myDT << Concatenate(tableNameList, append to first table);
for each({dt},tableNameList, close(dt, noSave))
zetaVagabond1
Level IV

Re: How to prevent a data table window from appearing when creating it via script in JMP?

Thanks for your detailed responses,I am not a seasoned JSL scripter and I have been trying to adapt to a legacy script. I find scripting in JSL very confusing  and daunting xD. I am more pythonic. 

I figured my way around without much context but phew!! 

 

Recommended Articles