cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Register for our Discovery Summit 2024 conference, Oct. 21-24, where you’ll learn, connect, and be inspired.
Choose Language Hide Translation Bar
robot
Level VI

Export JMP Table as JSON

Extending @Craige_Hales excellent answer in JSON <=> JMP, is there a way to convert a JMP table to a JSON file that will preserve the row order of the original table (for human readability)?  Using JMP 17.2.0.

1 REPLY 1
jthi
Super User

Re: Export JMP Table as JSON

To which format should this JMP table be changed to

jthi_0-1723003868338.png

New Table("Untitled",
	Add Rows(5),
	Compress File When Saved(1),
	New Column("name",
		Character,
		"Nominal",
		Set Values({"KATIE", "LOUISE", "JANE", "JACLYN", "LILLIE"})
	),
	New Column("age",
		Numeric,
		"Ordinal",
		Format("Fixed Dec", 5, 0),
		Set Values([12, 12, 12, 12, 12])
	),
	New Column("sex",
		Character(1),
		"Nominal",
		Set Values({"F", "F", "F", "F", "F"})
	),
	New Column("height",
		Numeric,
		"Continuous",
		Format("Fixed Dec", 5, 0),
		Set Values([59, 61, 55, 66, 52])
	),
	New Column("weight",
		Numeric,
		"Continuous",
		Format("Fixed Dec", 5, 0),
		Set Values([95, 123, 74, 145, 64])
	)
)

jthi_1-1723003928791.png

 

[
 {
  "name" : "KATIE",
  "age" : 12,
  "sex" : "F",
  "height" : 59,
  "weight" : 95
 },
 {
  "name" : "LOUISE",
  "age" : 12,
  "sex" : "F",
  "height" : 61,
  "weight" : 123
 },
 {
  "name" : "JANE",
  "age" : 12,
  "sex" : "F",
  "height" : 55,
  "weight" : 74
 },
 {
  "name" : "JACLYN",
  "age" : 12,
  "sex" : "F",
  "height" : 66,
  "weight" : 145
 },
 {
  "name" : "LILLIE",
  "age" : 12,
  "sex" : "F",
  "height" : 52,
  "weight" : 64
 }
]

Isn't the row order is preserved based on the order of items in the list?

 

-Jarmo