Split column into multiple column and creating JSON layout dynamically based on input column

[Anonymous]

Hi Everyone,

I have requirement to split column which is "," seperated and create Json Layout out of the split columns.
Input Field data Field1 : Cough,Chest Pain,Shortness of breathe
Output JSON layout:
{  
Type: Symptom,

Text: Cough
},

{

Type: Symptom,

Text: Chest Pain

},

.... so on .... Field1 can contain 0-11 types of symptoms. So Json should also have those many symptom. Can anyone please help on this,

[Anonymous]

Hi,

   Could you please send the Field1 data as input to tNormalize component. The data will be normalized as shown in sample scenario link.

https://help.talend.com/reader/mjoDghHoMPI0yuyZ83a13Q/TDU6BHwtwtPDIejeO6P6uA

   Once you get the normalized data, you can convert the data using tWriteJSONField where you can convert the data to JSON.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved