​​
Hello,

I am using DataImportHandler to index data from mongoDB.

Here's how my data-source-config file looks like:

<dataConfig>
<dataSource name="mongod" type="JdbcDataSource"
driver="com.mongodb.jdbc.MongoDriver" url="mongodb://<<IP
Address>>:27017/<<DB>>"/>
<document name="products">
entityA(Root Entity) -   *products*
   entityB (child=true,pk=unique field) - *skus*
      entityC - *attributevalues*
         entityD - *attributenames*
            entityE(child=true,pk=unique field) - *skupricelist*


When data is indexed separate  *skupricelist* documents are created for
each attribute (since *skupricelist* is child of *skus* and under
*attributenames*).How can I merge / join the all those skupricelist
documents with all attributes in same document?

example :
Right now the documents created are as follows:

Separate document 1
{
'PRODUCT NAME':'ABC',
'SKU NAME':'ABC-1',
'Color':'Red',
'SKUPricelist':'SKUPricelistA'
}

Separate document 2
{
'PRODUCT NAME':'ABC',
'SKU':'ABC-1',
'Size':'10',
'SKUPricelist':'SKUPricelistA'
}

Separate document 3
{
'PRODUCT NAME':'ABC',
'SKU':'ABC-1',
'Type':'Leather',
'SKUPricelist':'SKUPricelistA'
}

Is there a way I can join them like this?

{
'PRODUCT NAME':'ABC',
'SKU':'ABC-1',
'Color':'Red',
'Size':'10',
'Type':'Leather',
'SKUPricelist':'SKUPricelistA'
}

Thank You.
Regards,

Abhijit

Reply via email to