This should be easy but for some reason is oddly difficult and the documentation we have on this is minimalistic.
I want to import the attached JSON file, but the Tall Guess puts all times/values into one column, but what I want is two columns (one column for times, and the other column for values). The other guess (Wide, Huge, Pandas) don't work and stack yes/no doesn't help either.
JSON data attached, thanks in advance!
Hello @mzwald ,
I think your question is similar to the one on the following page.
https://community.jmp.com/t5/Discussions/How-to-load-the-JSON-data-into-a-data-table-with-proper-column/td-p/627675
You need to set a "columns" node to JSON header and "values" node to padas values.
I'm afraid I can't find the way to set the column name correctly.
Hi Yuichi,
Your solution did exactly what I was looking for, thanks! How did you know to use Pandas Values? I cannot find any documentation about it.
Mark
Hi @mzwald ,
Unfortunately, I don't think the documentation provides a detailed explanation of JSON import.
I have seen the video where developers talk about the feature internally.
https://community.jmp.com/t5/Technical-Reference-Library/DEV19-XML-amp-JSON-Import-Wizard-Developer-Webex-12-12-18/ta-p/258311
I hope it helps.
