I have a file with this schema:
Type PlaceA PlaceB PlaceC PlaceD PlaceE
Value per hour 1.56 2.76 1.64 1.75 3.54
Value per month 3.66 1.54 5.47 0.75 10.2
Value per year 0.13 7.31 0.12 8.11 1.21
I want to store values in a schema like this:
Place Value per hour Value per month Value per year
PlaceA 1.56 3.66 0.13
PlaceB 2.76 1.54 7.31
PlaceC 1.64 5.47 0.12
PlaceD 1.75 0.75 8.11
PlaceE 3.54 10.2 1.21
How can I do this? I only want to pivot the entire data.
Thanks in Advance.
Could you please have a look at this article:https://community.talend.com/t5/Migration-Configuration-and/Converting-rows-to-columns/ta-p/21667 to see if it is what you are looking for?
Here is a custom component tTranspose written by talend community user and shared on talend exchange portal which can move rows to columns / columns to rows.
Let us know if it works for you.
Are you able to provide the details of how you configured the tMap and the Java code you used? I want to create a pivot that I can output to HDFS rather than a delimited file. I believe your solution is the only way to do this.
Watch the recorded webinar!
Introduction to Talend Open Studio for Data Integration.
Test drive Talend's enterprise products.
Practical steps to developing your data integration strategy.