Hi,
You can try using tNormalize component along with tMap component. It worked for me. Below is the screenshot of my Job and the expressions I used for the transformation of the columns.
To perform this, add and link the components as shown below:![image](https://lh4.googleusercontent.com/7V61MD7KEJclkyxdRyR_jZUVhL8U3ObX15cl2ikemLGun20gqyDfhLPl9qo1Foi5mVEQzljOLhqAlDlp7aaL4TZ8zEwy73-NjQAhyTcK4Lj3vYeiIFeFHZBVNqt22MTlIiOpbXLO)
Once you are done setting up the components, go to the tMap component and concatenate your rows and columns with a semi-colon (;), as shown below:
![image](https://lh5.googleusercontent.com/VbZxhA5_dqmYOkX-vfLHdD-NiwSbTGJ_6e4yvBPR6rAUfa1UE2FTbmO4h6k9ZGH27ZMX-7TRWB2Zs16Q8u9_FCJNU1OXdyoCnq91HSKBKnBwlaLfroG6vFGRFhTKpOOeQUPArrlQ)
Finally, normalize the data, to get the desired input.
Hope this helps!
To know more about Talend, join Talend for big data certification training today.
Thanks.