Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Unable to iterate through multiple level fields in JSON file

Hello,
Below is my sample JSON file,

{
"merchant":[ { 
"_id":"ObjectId(55e3d639d118e6c24ee116f6)",
"name":"???? ??????",
"description":"???",
"website":"",
"taxonomy":"??,??,???",
"merchantLocation": [ {
                        "location":"china"
                      },
                      { "location":"australia"}
                    ]
}]

}


This is the output i get,

|_id                               |name       |description|website|taxonomy |location|
|=---------------------------------+-----------+-----------+-------+---------+-------

|ObjectId(55e3d639d118e6c24ee116f6)|???? ??????|???        |       |??,??,???|china   |

But I expect another row as output for location=australia.

Attached the talend mapping for your reference. Please help.

Thanks,
Satheesh
0683p000009MGlo.png

Labels (2)
3 Replies
Anonymous
Not applicable
Author

I believe your "Loop" should be set to "/merchantLocation"  in order to achieve this. Take a look at this example provided by Talend....
https://help.talend.com/search/all?query=tExtractJSONFields
Anonymous
Not applicable
Author

You should review JsonPath: http://goessner.net/articles/JsonPath/ 
Anonymous
Not applicable
Author

Thanks for the comments.. It worked!