topic Re: how to extract nested loop for json file in Talend Studio https://community.qlik.com/t5/Talend-Studio/how-to-extract-nested-loop-for-json-file/m-p/2482434#M141291 <P>Can you help me to steps to extract the json above json file .The above video is not helpful for me.</P> <P>regards,</P> <P>Chandu</P> Thu, 19 Sep 2024 06:23:09 GMT poorna4167 2024-09-19T06:23:09Z how to extract nested loop for json file https://community.qlik.com/t5/Talend-Studio/how-to-extract-nested-loop-for-json-file/m-p/2478168#M141182 <P>Hi,</P> <P>I am new into talend .Can you help me to extract the data from talend from below data.Need step by step procedure.</P> <P>&nbsp;</P> <DIV>{</DIV> <DIV>&nbsp; &nbsp; "CorporateData": {</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; "Rohan": {</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Year 2024": {</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Company": "Abcd",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Duration": "12 months",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "projects Done": "2",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Salary": "5LPA",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Joining_Date":"2022-03-21 14:00"</DIV> <DIV><SPAN> &nbsp;</SPAN></DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Year 2025": {</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Company": "Abcd",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Duration": "12 months",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "projects Done": "1",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Salary": "7LPA",</DIV> <DIV><SPAN> "Joining_Date":"2021-05-26 09:00"</SPAN></DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Year 2026": {</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Company": "Abcd",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Duration": "12 months",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "projects Done": "1",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Salary": "8LPA",</DIV> <DIV><SPAN> "Joining_Date":"2021-11-21 14:00"</SPAN></DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; },</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; "Ankur": {</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Year 2024": {</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Company": "EBD",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Duration": "12 months",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "projects Done": "2",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Salary": "8LPA",</DIV> <DIV><SPAN> "Joining_Date":"2020-11-21 16:00"</SPAN></DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Year 2025": {</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Company": "EBD",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Duration": "12 months",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "projects Done": "1",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Salary": "8LPA",</DIV> <DIV><SPAN> "Joining_Date":"2024-07-21 09:00"</SPAN></DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; },</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Year 2026": {</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Company": "EBD",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Duration": "12 months",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "projects Done": "2",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; "Salary": "10LPA",</DIV> <DIV><SPAN> "Joining_Date":"2021-11-21 19:00"</SPAN></DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; }</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</DIV> <DIV>&nbsp; &nbsp; },</DIV> <DIV>&nbsp; &nbsp; "meta": {</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; "consensus": "median",</DIV> <DIV>&nbsp; &nbsp; &nbsp; &nbsp; "updated": "2024-07-11"</DIV> <DIV>&nbsp; &nbsp; }</DIV> <DIV>}</DIV> Tue, 27 Aug 2024 10:22:03 GMT https://community.qlik.com/t5/Talend-Studio/how-to-extract-nested-loop-for-json-file/m-p/2478168#M141182 poorna4167 2024-08-27T10:22:03Z Re: how to extract nested loop for json file https://community.qlik.com/t5/Talend-Studio/how-to-extract-nested-loop-for-json-file/m-p/2478171#M141183 <P>Try the approach at the bottom of this one:</P> <P><A href="https://www.linkedin.com/pulse/omg-i-can-read-json-qlik-sense-christof-schwarz" target="_blank">https://www.linkedin.com/pulse/omg-i-can-read-json-qlik-sense-christof-schwarz</A></P> <P>&nbsp;</P> Tue, 27 Aug 2024 10:33:40 GMT https://community.qlik.com/t5/Talend-Studio/how-to-extract-nested-loop-for-json-file/m-p/2478171#M141183 Or 2024-08-27T10:33:40Z Re: how to extract nested loop for json file https://community.qlik.com/t5/Talend-Studio/how-to-extract-nested-loop-for-json-file/m-p/2482434#M141291 <P>Can you help me to steps to extract the json above json file .The above video is not helpful for me.</P> <P>regards,</P> <P>Chandu</P> Thu, 19 Sep 2024 06:23:09 GMT https://community.qlik.com/t5/Talend-Studio/how-to-extract-nested-loop-for-json-file/m-p/2482434#M141291 poorna4167 2024-09-19T06:23:09Z Re: how to extract nested loop for json file https://community.qlik.com/t5/Talend-Studio/how-to-extract-nested-loop-for-json-file/m-p/2482448#M141292 <P>Hello ,</P> <P>You can use this handy link <A href="https://jsonpathfinder.com/" target="_blank">https://jsonpathfinder.com/</A> to see which query to put in your tExtractJSONFields</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Dave_Simo_0-1726729237365.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/171892i62A3DF01712B557D/image-size/medium?v=v2&amp;px=400" role="button" title="Dave_Simo_0-1726729237365.png" alt="Dave_Simo_0-1726729237365.png" /></span></P> <P>&nbsp;</P> <P>Best Regards,</P> Thu, 19 Sep 2024 07:00:48 GMT https://community.qlik.com/t5/Talend-Studio/how-to-extract-nested-loop-for-json-file/m-p/2482448#M141292 Dave_Simo 2024-09-19T07:00:48Z