Share your ideas for the JMP Scripting Unsession at Discovery Summit by September 17th. We hope to see you there!
Choose Language Hide Translation Bar
Highlighted
dkraeuter_sunne
Level III

Import JSON Files

I am trying to import JSON files and the data comes in with the wrong formatting. Attached you will see images of the corrrect and incorrect way that the files import. To get the correct import view I have to save the file as a text file and then re-import the text file. What should I do to fix the import issues

Wrong FormattingWrong Formatting

 Right FormattingRight Formatting

 

 

 

2 REPLIES 2
Highlighted
Craige_Hales
Staff (Retired)

Re: Import JSON Files

You don't need to copy or rename the file to use JMP's text import. Use

open("$desktop/jsonfiles/zips.json","text")

the "text" option uses the CSV-style text import, which sees the Comma Separated Values in the json file and might do an acceptable import. Often not, since the records won't be on one line and the columns won't get reasonable names.

 

Can you share the file, or the first few lines of the file? I'd like to have that example as a test case.

 

What version of JMP are you using?

Craige
Highlighted
dkraeuter_sunne
Level III

Re: Import JSON Files

I cannot attach the file because it is not a valid extension allowed by the website. Is there another way that I can send this to you?

 

I tried the text import you listed below and it is closer to what I need, but it missed one set of columns because of the brackets that are around it.

Article Labels

    There are no labels assigned to this post.