Convert Nested Json file to Excel

Question

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 into multiple rows.Would someone be able to help me out here ?
 input.txt (2.1 KB)
currentoutput.xlsx (17.4 KB)
I have attached both Input and pipeline files here. Please assist
Thanks,
Muthu

tstack · Answer

Marimuthu86:

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 into multiple rows.

Have you tried the JSON Splitter snap?  Based on your input file, you are probably wanting to split $transcript.lines[*].

marimuthu86 · Answer

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)

neelamanikandan · Answer

Did you find a solution for this

Forum Discussion

Convert Nested Json file to Excel

3 Replies

Recent Discussions

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working

Can we generate XML file in pretty print format using native snapLogic snaps?

Multipart Reader failure - 'content-type' was not found