[resolved] Unable to create array within a sub doc array using tWriteJSONField

[Anonymous]

Dear Sir/Madam.

I am trying to create a json structure which contains fields and arrays (say 2) at the root level and the second array is kind of a sub document and within that there will be arrays. Please refer the attached screenshot.

I am using tWriteJSONField component in talend open studio for big data 6.2.1 and the problem facing is I am able to set only one looping element so I am not able to achieve the actual grain level of data.

When I set the looping element at the root level translations, translations within the colorCollections is getting missed and vice versa. And I need to achieve another array called colorNames within this sub doc array.

Please let me know if any further info required. 
Your help will be highly appreciated.

Thanks in advance for your support.
Kind regards,
Sathish

[Anonymous]

Hi,
Could you please elaborate your case with an example with input and expected output values?
Best regards
Sabrina

[Anonymous]

Hi Sabrina,

Input data .-------+----------------------+-----------------+--------+----------------+-----------------+----------------+----------------+----------------+------+------+------------------+-----------------+------------------+----------------+----------------+----------------+------+-----------+--------------+----+--------------+---------------+-------------------------. |                                                                                                                                                                        

To see the whole post, download it here
OriginalPost.pdf

[Anonymous]

Hi Sabrina,

Currently I am able to achieve 70% of the target json structure and inserting into the MongoDB. Still pending is the last level sub document array (colorNames).
Approach I followed is split the documents into 3 level based on the grain level, inserted into temp tables and then extracted again and joined. Will keep you posted if I face any issues.

Thanks in advance,
Kind regards,
Sathish