cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • 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
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