Sep 18, 2018 7:29 AM
| Last Modified: Sep 18, 2018 7:34 AM(2313 views)
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
You don't need to copy or rename the file to use JMP's text import. Use
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.