https://community.qlik.com/t5/Talend-Studio/Mongodb-Nested-documents-export-to-RDBMS/m-p/2292375#M65452 <P>Hi all,</P> <P>&nbsp;</P> <P>I have a situation where i need to take input from MongoDB documents stored in nested way and export it into RDBMS. However, when i'm trying to do the same its not getting done. I am new to talend and any help will be deeply appreciated.</P> <P>&nbsp;</P> <P>Here are the screenshots:</P> <P>&nbsp;</P> <P>MongoDB table:</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 503px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lxyw.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139283iB17DF01D9125271C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lxyw.png" alt="0683p000009Lxyw.png" /></span></SPAN></P> <P>&nbsp;</P> <P>i am facing issue to import line_data node into talend.</P> <P>&nbsp;</P> <P>MongoDB input settings:</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 713px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyMW.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138273iA0C497FCC5B798F0/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyMW.png" alt="0683p000009LyMW.png" /></span></SPAN></P> <P>&nbsp;</P> <P>TExtractJSONFields:</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 732px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lxua.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151512i5E65DEDF1A5AC43A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lxua.png" alt="0683p000009Lxua.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyMb.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138893i2FA97709AA5276D3/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyMb.png" alt="0683p000009LyMb.png" /></span></SPAN></P> <P>&nbsp;</P> <P>I know that error is in loopxpath query, but don't have any idea how to use the same. Kindly help me out in this issue.</P> <P>&nbsp;</P> <P>My job looks like this:</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 651px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ly4W.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152119i6983709DBDEDD195/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ly4W.png" alt="0683p000009Ly4W.png" /></span></SPAN></P> Sat, 16 Nov 2024 08:06:07 GMT Anonymous 2024-11-16T08:06:07Z https://community.qlik.com/t5/Talend-Studio/Mongodb-Nested-documents-export-to-RDBMS/m-p/2292375#M65452 <P>Hi all,</P> <P>&nbsp;</P> <P>I have a situation where i need to take input from MongoDB documents stored in nested way and export it into RDBMS. However, when i'm trying to do the same its not getting done. I am new to talend and any help will be deeply appreciated.</P> <P>&nbsp;</P> <P>Here are the screenshots:</P> <P>&nbsp;</P> <P>MongoDB table:</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 503px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lxyw.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/139283iB17DF01D9125271C/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lxyw.png" alt="0683p000009Lxyw.png" /></span></SPAN></P> <P>&nbsp;</P> <P>i am facing issue to import line_data node into talend.</P> <P>&nbsp;</P> <P>MongoDB input settings:</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 713px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyMW.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138273iA0C497FCC5B798F0/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyMW.png" alt="0683p000009LyMW.png" /></span></SPAN></P> <P>&nbsp;</P> <P>TExtractJSONFields:</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 732px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Lxua.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/151512i5E65DEDF1A5AC43A/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Lxua.png" alt="0683p000009Lxua.png" /></span></SPAN><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 999px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009LyMb.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/138893i2FA97709AA5276D3/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009LyMb.png" alt="0683p000009LyMb.png" /></span></SPAN></P> <P>&nbsp;</P> <P>I know that error is in loopxpath query, but don't have any idea how to use the same. Kindly help me out in this issue.</P> <P>&nbsp;</P> <P>My job looks like this:</P> <P>&nbsp;</P> <P><SPAN class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="image.png" style="width: 651px;"><span class="lia-inline-image-display-wrapper" image-alt="0683p000009Ly4W.png"><img src="https://community.qlik.com/t5/image/serverpage/image-id/152119i6983709DBDEDD195/image-size/large?v=v2&amp;px=999" role="button" title="0683p000009Ly4W.png" alt="0683p000009Ly4W.png" /></span></SPAN></P> Sat, 16 Nov 2024 08:06:07 GMT https://community.qlik.com/t5/Talend-Studio/Mongodb-Nested-documents-export-to-RDBMS/m-p/2292375#M65452 Anonymous 2024-11-16T08:06:07Z https://community.qlik.com/t5/Talend-Studio/Mongodb-Nested-documents-export-to-RDBMS/m-p/2292376#M65453 <P>Any Luck on this question?&nbsp;</P> Mon, 15 Jul 2019 20:57:50 GMT https://community.qlik.com/t5/Talend-Studio/Mongodb-Nested-documents-export-to-RDBMS/m-p/2292376#M65453 Anonymous 2019-07-15T20:57:50Z