912953_en-US

liliconcom

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:

 

<CODE class="whitespace-pre! language-jmp"><SPAN></SPAN>

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 );

Automation and ScriptingData Blending and CleanupRe: 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 
 

 

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))

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!!