Mongodb Nested documents export to RDBMS

Four Stars

Mongodb Nested documents export to RDBMS

Hi all,

 

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.

 

Here are the screenshots:

 

MongoDB table:

image.png

 

i am facing issue to import line_data node into talend.

 

MongoDB input settings:

 

image.png

 

TExtractJSONFields:

 

image.pngimage.png

 

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.

 

My job looks like this:

 

image.png