Unable to iterate through multiple level fields in JSON file

[Anonymous]

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

[Anonymous]

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]

You should review JsonPath: http://goessner.net/articles/JsonPath/ 

[Anonymous]

Thanks for the comments.. It worked!