topic Re: Normalization of data in Talend Studio

Normalization of data

Anonymous — Wed, 07 Nov 2018 06:15:28 GMT

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.

Re: Normalization of data

Anonymous — Fri, 30 Nov 2018 09:45:38 GMT

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

Re: Normalization of data

Anonymous — Fri, 30 Nov 2018 13:05:52 GMT

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.