topic Re: How to pivot rows and columns? in Talend Studio

How to pivot rows and columns?

Anonymous — Thu, 30 Nov 2017 11:22:58 GMT

Hello.

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.

Kind Regards.

Re: How to pivot rows and columns?

Arunachalam — Thu, 30 Nov 2017 14:35:26 GMT

Hi,

Use tPivotToColumnsDelimited component

Re: How to pivot rows and columns?

Anonymous — Tue, 05 Dec 2017 07:49:20 GMT

Hello,

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?

Best regards

Sabrina

Re: How to pivot rows and columns?

Anonymous — Mon, 11 Dec 2017 11:13:23 GMT

Hello, I solved it using tjava component writing some handcode and tmap component.

It's done.

Thanks!

Re: How to pivot rows and columns?

Anonymous — Thu, 14 Dec 2017 06:48:03 GMT

Hello,

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.

https://exchange.talend.com/#marketplaceproductoverview:marketplace=marketplace%252F1&p=marketplace%252F1%252Fproducts%252F187&pi=marketplace%252F1%252Fproducts%252F187%252Fitems%252F246

Let us know if it works for you.

Best regards

Sabrina

Re: How to pivot rows and columns?

Anonymous — Mon, 03 Dec 2018 13:35:03 GMT

Hi Sbiky,

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.

Thanks!