cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • JMP will suspend normal business operations for our Winter Holiday beginning on Wednesday, Dec. 24, 2025, at 5:00 p.m. ET (2:00 p.m. ET for JMP Accounts Receivable).
    Regular business hours will resume at 9:00 a.m. EST on Friday, Jan. 2, 2026.
  • We’re retiring the File Exchange at the end of this year. The JMP Marketplace is now your destination for add-ins and extensions.

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-353197%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%EC%9D%B4%20%ED%98%95%EC%8B%9D%EC%9D%98%20JSON%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20%ED%85%8C%EC%9D%B4%EB%B8%94%EB%A1%9C%20%EC%96%B4%EB%96%BB%EA%B2%8C%20%EB%B3%80%ED%99%98%ED%95%A0%20%EC%88%98%20%EC%9E%88%EB%82%98%EC%9A%94%3F%3C%2FLINGO-SUB%3E%0A%20%20%3CLINGO-BODY%20id%3D%22lingo-body-353197%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%0A%20%20%20%3CP%3E%EC%A0%84%EB%AC%B8%EA%B0%80%20%EC%97%AC%EB%9F%AC%EB%B6%84%2C%20%EA%B0%90%EC%82%AC%ED%95%A9%EB%8B%88%EB%8B%A4!%3C%2FP%3E%0A%20%20%20%3CBR%20%2F%3E%0A%20%20%20%3CP%3E%EC%A7%81%EC%A0%91%20%EC%9D%BD%EC%9D%80%20%EA%B2%B0%EA%B3%BC%EB%8A%94%20%EC%97%B4%EC%9E%85%EB%8B%88%EB%8B%A4.%3C%2FP%3E%0A%20%20%20%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3Ed1%3Djsontodatatable(txt)%3B%3C%2FCODE%3E%3C%2FPRE%3E%0A%20%20%20%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222021-01-27_18-49-05.png%22%20style%3D%22width%3A%20610px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222021-01-27_18-49-05.png%22%20style%3D%22width%3A%20610px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F29767i81DACF28B8282A84%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222021-01-27_18-49-05.png%22%20alt%3D%222021-01-27_18-49-05.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%20%20%20%3CPRE%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FPRE%3E%0A%20%20%20%3CBR%20%2F%3E%0A%20%20%20%3CBR%20%2F%3E%0A%20%20%20%3CP%3EJSL%EC%9D%84%20%EC%82%AC%EC%9A%A9%ED%95%98%EC%97%AC%20JSON%20%EB%8D%B0%EC%9D%B4%ED%84%B0%EB%A5%BC%20%EC%95%84%EB%9E%98%20%ED%91%9C%EB%A1%9C%20%EA%B5%AC%EC%84%B1%ED%95%98%EB%8A%94%20%EB%B0%A9%EB%B2%95%EC%9E%85%EB%8B%88%EB%8B%A4.%20%EA%B0%90%EC%82%AC%ED%95%A9%EB%8B%88%EB%8B%A4!%3C%2FP%3E%0A%20%20%20%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222021-01-27_18-38-43.png%22%20style%3D%22width%3A%20911px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%222021-01-27_18-38-43.png%22%20style%3D%22width%3A%20911px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F29766i84519B450FF86012%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222021-01-27_18-38-43.png%22%20alt%3D%222021-01-27_18-38-43.png%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%20%20%3C%2FLINGO-BODY%3E%0A%20%20%3CLINGO-LABS%20id%3D%22lingo-labs-353197%22%20slang%3D%22en-US%22%20mode%3D%22UPDATE%22%3E%0A%20%20%20%3CLINGO-LABEL%3E%EC%9E%90%EB%8F%99%ED%99%94%20%EB%B0%8F%20%EC%8A%A4%ED%81%AC%EB%A6%BD%ED%8C%85%3C%2FLINGO-LABEL%3E%0A%20%20%20%3CLINGO-LABEL%3E%EC%BD%98%ED%85%90%EC%B8%A0%20%EA%B5%AC%EC%84%B1%3C%2FLINGO-LABEL%3E%0A%20%20%20%3CLINGO-LABEL%3E%EB%8D%B0%EC%9D%B4%ED%84%B0%20%EC%95%A1%EC%84%B8%EC%8A%A4%3C%2FLINGO-LABEL%3E%0A%20%20%20%3CLINGO-LABEL%3E%EB%8C%80%EB%9F%89%20%EB%A7%9E%EC%B6%A4%ED%99%94%3C%2FLINGO-LABEL%3E%0A%20%20%20%3CLINGO-LABEL%3E%ED%92%88%EC%A7%88%20%EB%B0%8F%20%EA%B3%B5%EC%A0%95%20%EC%97%94%EC%A7%80%EB%8B%88%EC%96%B4%EB%A7%81%3C%2FLINGO-LABEL%3E%0A%20%20%20%3CLINGO-LABEL%3E%EA%B2%B0%EA%B3%BC%20%EA%B3%B5%EC%9C%A0%20%EB%B0%8F%20%EC%A0%84%EB%8B%AC%3C%2FLINGO-LABEL%3E%0A%20%20%3C%2FLINGO-LABS%3E
Choose Language Hide Translation Bar
lwx228
Level VIII

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

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

1 REPLY 1

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

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

Recommended Articles