3709_en-US

liliconcom

Importing an XML file into JMP

Hi guys,

 

Any one try to use JMP to work with XML file before? Can JMP import XML file?

Re: Reading 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).

The wizard looks similar for both XML and JSON filesThe wizard looks similar for both XML and JSON filesThe wizard looks similar for both XML and JSON files

 

 

Re: Reading XML file

try the addin.

https://community.jmp.com/t5/JMP-Add-Ins/XML-Importer-Add-In/ta-p/22723

Output from XML addinOutput from XML addinOutput from XML addin

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.)

Re: Reading XML file

Having the same problem.  The documentation does not go into much details on this.

Re: Reading XML file<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

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:

-

  -

    AA11

    1.0

    -

      AA11

      0

      -

        AA11

        1

            

     

   

Re: Reading XML file

JMP has functions for loading and parsing XML.

If you have the XML as text strings, use ParseXML

 

ex =
"[1 2 3][11 22 33]";
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() ) )
               )
          )
     )
);