cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
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 IV

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