Forum Discussion

Marimuthu86's avatar
Marimuthu86
New Contributor II
7 years ago

Convert Nested Json file to Excel

Hi, I’m working on a requirement to convert Nested Json file to .xls format, but facing some bottlenecks in getting required output. The output shows list of values in cells instead of breaking int...
sindhu's avatar
sindhu
New Contributor II
5 years ago

Found solution for this. Thanks

philliperamos's avatar
philliperamos
Contributor
4 years ago

Can you please post the solution as we have a similar use case.
Thanks.

  • Marimuthu86's avatar
    Marimuthu86
    New Contributor II
    7 years ago

    Yes, along with Transcript, i would need to split all levels inside the file.
    For each level of split, i’m forced to use multiple JSON Splitter. Attaching the full version of file along with pipeline that i created. Could you please help me out with the steps to read this JSON file and write output to Excel format.

    Test-Full_2018_09_08.slp (25.9 KB)
    Arno_Sample1.txt (1.9 MB)