Hi guys,
Any one try to use JMP to work with XML file before? Can JMP import XML file?
Anyone landing here for JMP 15 and beyond: there is built-in support for reading XML and JSON data that includes a GUI-based wizard. (JMP 14 has non-GUI support for JSON as well).
JMP has functions for loading and parsing XML.
If you have the XML as text strings, use ParseXML
ex =
"<table name='fromxml'><col name='x'>[1 2 3]</col><col name='y'>[11 22 33]</col></table>";
Parse XML( ex,
On Element(
"table",
Start Tag(
New Table( XML Attr( "name" ) )
)
),
On Element(
"col",
End Tag(
New Column( XML Attr( "name" ),
Set Values( Parse( XML Text() ) )
)
)
)
);
From a file:
Parse XML( LoadTextFile("c:\temp\test.xml"),
"table",
On Element(
Start Tag(
New Table( XML Attr( "name" ) )
)
),
On Element(
"col",
End Tag(
New Column( XML Attr( "name" ),
Set Values( Parse( XML Text() ) )
)
)
)
);
Hi Jschroedl,
I have an XML file with contents as shown below. I was trying to create a JMP table from it.
How do i write the jsl so that I can pick up the value in the 'Type' field in folder "CD" which would be '0' and not pick up the '1' from the "DD" folder (also with a 'Type' field but is within "CD")?
Thanks.
XML contents:
- <Summary_Log>
- <Info>
<UID>AA11</UID>
<Ver>1.0</Ver>
- <CD>
<UID>AA11</UID>
<Type>0</Type>
- <DD>
<UID>AA11</UID>
<Type>1</Type>
</DD>
</CD>
</Info>
</Summary_Log>
Having the same problem. The documentation does not go into much details on this.
try the addin.
https://community.jmp.com/t5/JMP-Add-Ins/XML-Importer-Add-In/ta-p/22723
The column names are the fully qualified path through the XML document.
(The addin source JSL is there too. View->add-ins->open the folder and see the JSL.)
Anyone landing here for JMP 15 and beyond: there is built-in support for reading XML and JSON data that includes a GUI-based wizard. (JMP 14 has non-GUI support for JSON as well).