JSON loop query

[RVeitch_84]

Noob question...

I'm trying to parse a json file, here is an example outline and I have attached the example file.

Basically I have an order id & location_id with 2 line_items and 2 tenders.

I would like to have the following output (see attached sample.txt), but can't figure out how to setup tFileInputJSON to get it to work?

Thanks for any help.

[Anonymous]

Hi

There are two loop elements line_items and tenders in this json file, you need two tFileInputJson components to read separately each loop element, then merge all the columns based on the same order id in next subjob.

Regards

Shong

[tjohn]

Hi

hope this will help . Please find below screenshots :