Normalization of data

[Anonymous]

Hi,

I have data coming like below from the source-

postDynamics Post_Engagement_Score
"Likes and Votes","0","Unique Commenters","0","Engagement","0","Reply Count","5" 446759
"Likes and Votes","0","Unique Commenters","0","Engagement","0","Reply Count","5" 446759

I want to normalize the data and it should look like below-

Post_Engagement_Score                post_Dynamics            values

       446759                                      "Likes and Votes"          "0"

       446759                                       "Unique Commenters"  "0"

Can you please guide how to achieve the same. 

[Anonymous]

Hello,

Could you pleas give us some description about your data normalization?  Is this component tNormalize working for your use case?

https://help.talend.com/reader/Btf8zDsnT4ikhQgFW1plpQ/ZrPFEQ1WxDKUMV_reJcHCA

Best regards

Sabrina

[Anonymous]

You can use tMap along with Java's String.split() function to split the first field on the comma into separate fields. Then, you just need to re-arrange the fields to get the desired output. Here is a post that describes this in more detail:

https://community.talend.com/t5/Design-and-Development/How-to-use-String-split-function/td-p/106383

Hope this helps.