https://community.qlik.com/t5/Talend-Studio/JSON-loop-query/m-p/2369740#M132856 <P>Noob question...</P><P></P><P></P><P>I'm trying to parse a json file, here is an example outline and I have attached the example file.</P><P></P><P></P><P>Basically I have an order id &amp; location_id with 2 line_items and 2 tenders.</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000JO9pbAAD.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146522i284EA7D90A4DB5F4/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000JO9pbAAD.jpg" alt="0695b00000JO9pbAAD.jpg" /></span></P><P></P><P></P><P></P><P></P><P>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?</P><P></P><P></P><P></P><P></P><P>Thanks for any help.</P> Fri, 15 Nov 2024 23:40:00 GMT RVeitch_84 2024-11-15T23:40:00Z https://community.qlik.com/t5/Talend-Studio/JSON-loop-query/m-p/2369740#M132856 <P>Noob question...</P><P></P><P></P><P>I'm trying to parse a json file, here is an example outline and I have attached the example file.</P><P></P><P></P><P>Basically I have an order id &amp; location_id with 2 line_items and 2 tenders.</P><P></P><P></P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000JO9pbAAD.jpg"><img src="https://community.qlik.com/t5/image/serverpage/image-id/146522i284EA7D90A4DB5F4/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000JO9pbAAD.jpg" alt="0695b00000JO9pbAAD.jpg" /></span></P><P></P><P></P><P></P><P></P><P>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?</P><P></P><P></P><P></P><P></P><P>Thanks for any help.</P> Fri, 15 Nov 2024 23:40:00 GMT https://community.qlik.com/t5/Talend-Studio/JSON-loop-query/m-p/2369740#M132856 RVeitch_84 2024-11-15T23:40:00Z https://community.qlik.com/t5/Talend-Studio/JSON-loop-query/m-p/2369741#M132857 <P>Hi</P><P>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. </P><P>&nbsp;</P><P>Regards</P><P>Shong</P> Sat, 09 Oct 2021 08:46:17 GMT https://community.qlik.com/t5/Talend-Studio/JSON-loop-query/m-p/2369741#M132857 Anonymous 2021-10-09T08:46:17Z https://community.qlik.com/t5/Talend-Studio/JSON-loop-query/m-p/2369742#M132858 <P>Hi</P><P>hope this will help . Please find below screenshots : </P><P><span class="lia-inline-image-display-wrapper" image-alt="0695b00000JPRoOAAX.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152428i4ADF0E0E14253CA6/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000JPRoOAAX.png" alt="0695b00000JPRoOAAX.png" /></span><span class="lia-inline-image-display-wrapper" image-alt="0695b00000JPRoTAAX.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/130544iCB3BA8D3BB2F7A06/image-size/large?v=v2&amp;px=999" role="button" title="0695b00000JPRoTAAX.png" alt="0695b00000JPRoTAAX.png" /></span></P> Sun, 10 Oct 2021 15:33:23 GMT https://community.qlik.com/t5/Talend-Studio/JSON-loop-query/m-p/2369742#M132858 tjohn 2021-10-10T15:33:23Z