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
isabellet14
Level II

How to make an SQL table Invisible?

I have another "invisible" question. I made an SQL table (from Query Builder) and want to modify my JSL to make that table invisible. I've tried adding "Invisible" to many different places, but none have worked. Is there a different syntax for making a Query Builder table invisible? Here is my code - thanks in advance for the help!

dt1=New SQL Query(

Version( 130 ),

Connection( "JMP" ),

["JMP_Table" =>

"Tablelocation.jmp"

QueryName( "SQLQuery1" ),

Column(

"example",

"t1",

Alias( "exampleAlias" )

Column(

"example2",

"t1",

Alias( "exampleAlias2" ) 

Column(

"example3",

"t1",

Alias( "exampleAlias3" )

From( Table( "JMP_Table", Alias( "t1" ) ) )

) << Run;

1 ACCEPTED SOLUTION

Accepted Solutions
pmroz
Super User

Re: How to make an SQL table Invisible?

Strange that the invisible keyword is not available here.  Try using << show window(0); that will make your table invisible.  Here's a simple example:

dt = open("$sample_data\Big Class.jmp");

dt <<Show Window(0);


View solution in original post

2 REPLIES 2
pmroz
Super User

Re: How to make an SQL table Invisible?

Strange that the invisible keyword is not available here.  Try using << show window(0); that will make your table invisible.  Here's a simple example:

dt = open("$sample_data\Big Class.jmp");

dt <<Show Window(0);


isabellet14
Level II

Re: How to make an SQL table Invisible?

That did it - Thanks so much for the quick help!

Recommended Articles