1
JSON to De-normalized Text/Csv file
Question asked by PHANI VURAKARANAM - May 7 at 3:53 AM
Answered
Hello, 
 
I am using the trial version of Liquid XML to convert a JSON file into a de-normalized tab-delimited text file. 
The JSON schema was inferred using Liquid XML.
My objective is to traverse through every node (starting from the root node) and list it as a separate record in the target text file. For example, if the hierarchy in the Json file is 
as Parent
        Child 
                GrandChild1
                GrandChild2
 
I want the text file to have 2 rows consisting of 
Parent Child GrandChild1
Parent Child GrandChild2. 
 
In addition, I would like to know if there is a function or a feature in that would allow me to add a row number for 
each record. 
 
Thanks
Phani

1 Reply

Reply to Thread
0
Liquid Support Replied
May 8 at 8:51 AM
Employee Post
Hi Phani
 
Unfortunately, we currently don't support recursive functions, so this is not currently possible, but it is something that is on our roadmap.
To answer the second part of your question, each item can be given a row number using the Position component.
 
 
 

Reply to Thread