cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Check out the JMP® Marketplace featured Capability Explorer add-in
Choose Language Hide Translation Bar
lwx228
lwx228
Level VIII

How can convert JSON data in this format into a table?

Created: Jan 27, 2021 05:50 AM  |  Last Modified: Jun 9, 2023 3:04 PM (1095 views)

Thanks Experts!

 

The result of a direct read is a column.

d1=jsontodatatable(txt);

2021-01-27_18-49-05.png



 

 

How to use JSL to organize this JSON data into the table below.Thank you very much!

2021-01-27_18-38-43.png

test.json
0 Kudos
1 REPLY 1
Mark_Bailey
Staff Mark_Bailey
Staff

Re: How can convert JSON data in this format into a table?

Jan 27, 2021 09:24 AM (1059 views)  |  Posted in reply to message from lwx228 01-27-2021

I bet you could learn a lot from this blog post.

0 Kudos