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