Hello, Abhijit. Have you tried to drop some of child=true? They usually cause slicing to separate documents, rather than default "merge to root" mode.
On Sun, May 27, 2018 at 9:48 PM, Abhijit Pawar <abhijit.ibizs...@gmail.com> wrote: > > 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 > -- Sincerely yours Mikhail Khludnev