https://community.qlik.com/t5/Talend-Studio/tExtractJSONFields-returns-null-values-after-extracting-fields/m-p/2239423#M27216 <P>Hello community<BR />I am using tFileInputJSON to get my json file and i passed this file to&nbsp;tExtractJSONFields to extract fields values but the values are null&nbsp;</P> <P>&nbsp;</P> <P>this is my BDConnection</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="bdConnection.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA2Y.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/137490iD9CDD73833D4CC90/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA2Y.png" alt="0683p000009MA2Y.png" /></span></SPAN></P> <P>&nbsp;</P> <P>this is my tFileInputJSON and the json file&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tFileInputjson.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA2F.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144907i94C30442801B7C4A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA2F.png" alt="0683p000009MA2F.png" /></span></SPAN></P> <P>&nbsp;</P> <P>this is my tExtractJSONFields&nbsp;&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tExtractJsonFields.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA2i.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/155785i3160DE41B9DBB14B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA2i.png" alt="0683p000009MA2i.png" /></span></SPAN></P> <P>&nbsp;</P> <P>this is the result</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="result.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9wR.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135842i977E22762B8C5E66/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9wR.png" alt="0683p000009M9wR.png" /></span></SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>i want to know why it returns null values&nbsp;</P> <P>Can someone please help me with this?</P> <P>&nbsp;</P> <P>Thanks</P> Sat, 16 Nov 2024 03:02:05 GMT Anonymous 2024-11-16T03:02:05Z https://community.qlik.com/t5/Talend-Studio/tExtractJSONFields-returns-null-values-after-extracting-fields/m-p/2239423#M27216 <P>Hello community<BR />I am using tFileInputJSON to get my json file and i passed this file to&nbsp;tExtractJSONFields to extract fields values but the values are null&nbsp;</P> <P>&nbsp;</P> <P>this is my BDConnection</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="bdConnection.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA2Y.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/137490iD9CDD73833D4CC90/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA2Y.png" alt="0683p000009MA2Y.png" /></span></SPAN></P> <P>&nbsp;</P> <P>this is my tFileInputJSON and the json file&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tFileInputjson.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA2F.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/144907i94C30442801B7C4A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA2F.png" alt="0683p000009MA2F.png" /></span></SPAN></P> <P>&nbsp;</P> <P>this is my tExtractJSONFields&nbsp;&nbsp;</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="tExtractJsonFields.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009MA2i.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/155785i3160DE41B9DBB14B/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009MA2i.png" alt="0683p000009MA2i.png" /></span></SPAN></P> <P>&nbsp;</P> <P>this is the result</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="result.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009M9wR.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/135842i977E22762B8C5E66/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009M9wR.png" alt="0683p000009M9wR.png" /></span></SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>i want to know why it returns null values&nbsp;</P> <P>Can someone please help me with this?</P> <P>&nbsp;</P> <P>Thanks</P> Sat, 16 Nov 2024 03:02:05 GMT https://community.qlik.com/t5/Talend-Studio/tExtractJSONFields-returns-null-values-after-extracting-fields/m-p/2239423#M27216 Anonymous 2024-11-16T03:02:05Z