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

How to assign a data table reference to table opened by jmpquery?

Is there a way in JSL to assign a table created from a jmpquery execution?

Instead of:

dtBigClass = open("BigClass.jmp");

I would like to assign "dtBigClass" to a jmpquery that I just executed.

 

Many thanks,

 

John

2 REPLIES 2
David_Burnham
Super User (Alumni)

Re: How to assign a data table reference to table opened by jmpquery?

have you tried dt = bla bla bla where bla bla bla is the query ?

 

e.g.

 

New SQL Query(
	Version( 130 ),
	Connection( "JMP" ),
	JMP Tables(
		["Montgomery battery life ANOVA example" =>
		"\C:\Users\Pega-MAC\Downloads\Montgomery battery life ANOVA example.jmp"]
	),
	QueryName( "SQLQuery1" ),
	Select(
		Column( "Material type", "t1", Analysis Type( "Nominal" ) ),
		Column( "Temperature", "t1", Analysis Type( "Nominal" ) ),
		Column( "Life (in hours)", "t1" )
	),
	From( Table( "Montgomery battery life ANOVA example", Alias( "t1" ) ) )
) << Run;

 

where New SQL Query ... was gotten from the source script attached to the output data table. 

-Dave
Mauro_Gerber
Level V

Re: How to assign a data table reference to table opened by jmpquery?

If you want to use the Query Builder, use the following code:

 

dt1 = Open("file1.jmp");
dt2 = Open("file2.jmp");

dtQuery =  dt1 << JMP Query Builder();

You can now work with both table.

"I thought about our dilemma, and I came up with a solution that I honestly think works out best for one of both of us"
- GLaDOS

Recommended Articles