cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Learn how to build custom Python data connectors and further customize JMP’s Data Connector Framework with the Python Data Connector Demo, available now in the JMP Marketplace!
  • See how to create experiments to support product design and ID useful product features. Register for June 12 webinar, 2pm US Eastern Time.

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