cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Try the Materials Informatics Toolkit, which is designed to easily handle SMILES data. This and other helpful add-ins are available in the JMP® Marketplace
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