topic Re: [resolved] Unable to create array within a sub doc array using tWriteJSONField in Talend Studio

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

Anonymous — Sat, 16 Nov 2024 10:22:52 GMT

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

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

Anonymous — Wed, 21 Sep 2016 08:54:20 GMT

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

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

Anonymous — Wed, 21 Sep 2016 12:46:16 GMT

Hi Sabrina,

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

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

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

Anonymous — Wed, 21 Sep 2016 15:20:46 GMT

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