cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

Discussions

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

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 III

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