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

Anonymous — Sat, 16 Nov 2024 04:27:03 GMT

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,

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

Anonymous — Mon, 07 Oct 2019 20:51:07 GMT

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

topic Re: Split column into multiple column and creating JSON layout dynamically based on input column in Talend Studio

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

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