https://community.jmp.com/t5/Discussions/How-can-convert-JSON-data-in-this-format-into-a-table/m-p/353197#M60256 <P>Thanks Experts!</P><P>&nbsp;</P><P>The result of a direct read is a column.</P><PRE><CODE class=" language-jsl">d1=jsontodatatable(txt);</CODE></PRE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2021-01-27_18-49-05.png" style="width: 610px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/29767i81DACF28B8282A84/image-size/large?v=v2&amp;px=999" role="button" title="2021-01-27_18-49-05.png" alt="2021-01-27_18-49-05.png" /></span></P><PRE><BR /><BR /></PRE><P>&nbsp;</P><P>&nbsp;</P><P>How to use JSL to organize this JSON data into the table below.Thank you very much!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2021-01-27_18-38-43.png" style="width: 911px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/29766i84519B450FF86012/image-size/large?v=v2&amp;px=999" role="button" title="2021-01-27_18-38-43.png" alt="2021-01-27_18-38-43.png" /></span></P> Fri, 09 Jun 2023 22:04:21 GMT lwx228 2023-06-09T22:04:21Z https://community.jmp.com/t5/Discussions/How-can-convert-JSON-data-in-this-format-into-a-table/m-p/353197#M60256 <P>Thanks Experts!</P><P>&nbsp;</P><P>The result of a direct read is a column.</P><PRE><CODE class=" language-jsl">d1=jsontodatatable(txt);</CODE></PRE><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2021-01-27_18-49-05.png" style="width: 610px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/29767i81DACF28B8282A84/image-size/large?v=v2&amp;px=999" role="button" title="2021-01-27_18-49-05.png" alt="2021-01-27_18-49-05.png" /></span></P><PRE><BR /><BR /></PRE><P>&nbsp;</P><P>&nbsp;</P><P>How to use JSL to organize this JSON data into the table below.Thank you very much!</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="2021-01-27_18-38-43.png" style="width: 911px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/29766i84519B450FF86012/image-size/large?v=v2&amp;px=999" role="button" title="2021-01-27_18-38-43.png" alt="2021-01-27_18-38-43.png" /></span></P> Fri, 09 Jun 2023 22:04:21 GMT https://community.jmp.com/t5/Discussions/How-can-convert-JSON-data-in-this-format-into-a-table/m-p/353197#M60256 lwx228 2023-06-09T22:04:21Z https://community.jmp.com/t5/Discussions/How-can-convert-JSON-data-in-this-format-into-a-table/m-p/353245#M60265 <P>I bet you could learn a lot from this <A href="https://community.jmp.com/t5/Uncharted/Fast-JSON-Parsing-using-Pattern-Matching/ba-p/21161" target="_self">blog post</A>.</P> Wed, 27 Jan 2021 14:24:04 GMT https://community.jmp.com/t5/Discussions/How-can-convert-JSON-data-in-this-format-into-a-table/m-p/353245#M60265 Mark_Bailey 2021-01-27T14:24:04Z