topic Iterate on JSON array in Talend Studio https://community.qlik.com/t5/Talend-Studio/Iterate-on-JSON-array/m-p/2333620#M102386 Hi to all, I've a JSON file like this one:<BR /><PRE><BR />}]<BR /></PRE><BR />I need to get an unique record with "codiceCatastale" and "cap". So, like this:<BR /><PRE>|=--+---=|<BR />|codiceCatastale|cap|<BR />|=--------------+----=|<BR />|A001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |35031|<BR />|A271 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |60121|<BR />|A271 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |60122|<BR />|A271 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |60123|<BR />'---------------+-----'</PRE><BR />I try with tExtractJSONFields with success...<BR /><BR />Any suggestions?<BR />Thanks a lot<BR />Stefano Fri, 24 Mar 2017 18:34:33 GMT spassiatore 2017-03-24T18:34:33Z Iterate on JSON array https://community.qlik.com/t5/Talend-Studio/Iterate-on-JSON-array/m-p/2333620#M102386 Hi to all, I've a JSON file like this one:<BR /><PRE><BR />}]<BR /></PRE><BR />I need to get an unique record with "codiceCatastale" and "cap". So, like this:<BR /><PRE>|=--+---=|<BR />|codiceCatastale|cap|<BR />|=--------------+----=|<BR />|A001 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |35031|<BR />|A271 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |60121|<BR />|A271 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |60122|<BR />|A271 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; |60123|<BR />'---------------+-----'</PRE><BR />I try with tExtractJSONFields with success...<BR /><BR />Any suggestions?<BR />Thanks a lot<BR />Stefano Fri, 24 Mar 2017 18:34:33 GMT https://community.qlik.com/t5/Talend-Studio/Iterate-on-JSON-array/m-p/2333620#M102386 spassiatore 2017-03-24T18:34:33Z Re: Iterate on JSON array https://community.qlik.com/t5/Talend-Studio/Iterate-on-JSON-array/m-p/2333621#M102387 Hi &nbsp; <BR />Using a tFileInputJson component to read this json file, set the Loop Json query to "/cap", then you should be able to extract codiceCatastale and cap value.&nbsp; <BR /> <span class="lia-inline-image-display-wrapper" image-alt="0683p000009MDfn.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/132952i8FA84B11007F3729/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MDfn.png" alt="0683p000009MDfn.png" /></span> <BR />Regards <BR />Shong Tue, 28 Mar 2017 15:25:13 GMT https://community.qlik.com/t5/Talend-Studio/Iterate-on-JSON-array/m-p/2333621#M102387 Anonymous 2017-03-28T15:25:13Z