Normalize 2 (or more) columns at the same time

Anonymous — Wed, 02 Dec 2015 07:50:38 GMT

Hello,
I knew that we can do the normalization for 1 column to multiple rows by using tNormalize. And we also can do do the normalization for 2 column by using tNormalize + apply java code. tNormalize 2 columns
My question is: Is there any way that allow me to do normalization for 2 columns (or more) at the same time (same steps). Meaning I just need to write java code to define the function and can apply it for all the columns that I want to normalize? Or Is there any provided function that can help me do that.

My Input:
row1;blue,green;1,2
row2;black,white,red;3,4,5
My expected results:
row1;blue
row1;green
row1;1
row1;2
row2;black
row2;white
row2;red
row2;3
row2;4
row2;5
Thank you and Best Regards,

Re: Normalize 2 (or more) columns at the same time

Anonymous — Mon, 07 Dec 2015 00:46:33 GMT

There is no a built in function can be used to do the normalization now. For your example, you can achieve it simply with tNormalize component. If you want to normalize 2 or more column at the same time, I think you need to split the columns into multiple flows, eg:
c1;c2;c3;c4==>flow1: c1;c2
flow2: c3;c4
Then, do the normalization on each flow, do an inner job to merge all the columns from the two flows.

topic Re: Normalize 2 (or more) columns at the same time in Talend Studio

Normalize 2 (or more) columns at the same time

Re: Normalize 2 (or more) columns at the same time