topic Re: Normalize Mysql Table from horizontal to vertical in Talend Studio

Normalize Mysql Table from horizontal to vertical

Anonymous — Wed, 21 May 2014 09:50:49 GMT

Re: Normalize Mysql Table from horizontal to vertical

Anonymous — Wed, 21 May 2014 10:02:16 GMT

Hi,
Please check similar thread
https://community.talend.com/t5/Design-and-Development/How-to-convert-rows-into-columns/td-p/102244
Where I have given few steps to achieve the objective which is similar to your requirement
Vaibhav

Re: Normalize Mysql Table from horizontal to vertical

Anonymous — Wed, 21 May 2014 11:13:02 GMT

yes you can normalise your data using tNormalize component. i am able to obtain desire output as you mention in initial post.
in tmap i have concatenated all the columns in single one except id column.

row7.Column1+";"+row7.Column2+";"+row7.Column3+";"+row7.Column4+";"+row7.Column5

check the pictures for more information.

Re: Normalize Mysql Table from horizontal to vertical

Anonymous — Wed, 21 May 2014 11:14:55 GMT

actually this doesn't fit good with my scenario.
i prefer to take a Mysql Input with the row table shown before and transform each row into an array,
then pass the array to the Mysql Output.
This seems possible with a tJavaFlex, but i actually don't know if it's possibile with talend.
Do you have any hint?

Re: Normalize Mysql Table from horizontal to vertical

Anonymous — Wed, 21 May 2014 11:21:51 GMT

instead file you can connect with MySQL and follow the same way, and pass output to MySQL. make me correct if i am wrong.

Re: Normalize Mysql Table from horizontal to vertical

Anonymous — Wed, 21 May 2014 11:58:19 GMT