cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Sign-in to the JMP Community will be unavailable intermittently Dec. 6-7 due to a system update. Thank you for your understanding!
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.
  • JMP 19 is here! Learn more about the new features.

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