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

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

lrmc_may — Wed, 17 Apr 2024 07:48:19 GMT

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");

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

jthi — Wed, 17 Apr 2024 07:49:39 GMT

What type of problem are you facing?

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

lrmc_may — Wed, 17 Apr 2024 07:52:01 GMT

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

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

lrmc_may — Wed, 17 Apr 2024 07:52:49 GMT

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

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

jthi — Wed, 17 Apr 2024 08:30:45 GMT

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