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

Problem with Opening file (tried to make it a flexible dt name in JSL)

Names Default To Here(1);

//Open Data Table: Recovery_Analysis:Plate Name.jmp
Recovery_Analysis:Plate Name = Open("MY FILEPATH");
 
//Split data table
Recovery_Analysis:Plate Name << Split(
	Split By(:Chemistry),
	Split(:Concentration),
	Group(:Well Id),
	Output Table("Untitled 17.jmp"),
	Sort by Column Property
);
 
//Save data table: Recovery_Analysis:Plate Name.jmp
Recovery_Analysis:Plate Name << Save("MY FILEPATH");
4 REPLIES 4
jthi
Super User

Re: Problem with Opening file (tried to make it a flexible dt name in JSL)

What type of problem are you facing?

-Jarmo
lrmc_may
Level II

Re: Problem with Opening file (tried to make it a flexible dt name in JSL)

Hi, im facing an Error message in the very first line with Open.. (sry im a beginner)

lrmc_may
Level II

Re: Problem with Opening file (tried to make it a flexible dt name in JSL)

i just replaced "MY FILE PATH" in here to not post my actual file path

jthi
Super User

Re: Problem with Opening file (tried to make it a flexible dt name in JSL)

What type of error message? Something like:

"The namespace "Recovery_Analysis" is not defined in access or evaluation of 'Recovery_Analysis:Plate Name' , Recovery_Analysis:Plate Name"

 

Most likely you don't need to use namespaces (the part before your table name) and something like this would be enough

 

Names Default To Here(1);

dt = Open("C:\Program Files\SAS\JMPPRO\16\Samples\Data\Big Class.jmp");
Names Default To Here(1);

dt = Open("MY FILEPATH"); 

dt_split = dt << Split(
	Split By(:Chemistry),
	Split(:Concentration),
	Group(:Well Id),
	Output Table("Split table"),
	Sort by Column Property
);
 
dt_split << Save("MY FILEPATH FOR SPLIT TABLE");

be careful to not overwrite your non-split table

 

-Jarmo

Recommended Articles