topic Pivot several columns to row in Talend Studio

Pivot several columns to row

jozeph — Sat, 16 Nov 2024 03:31:06 GMT

Hello.

I have a file with this schema:

Name Desc Year Type Client
Project A Project A Desc 2011 IT Client Z
Project B Project B Desc 2012 Non IT Client X
Project C Project C Desc 2013 IT Client Z
Project D Project D Desc 2014 IT Client X

I want to get values in a schema like this:

Pivot Name Pivot Value Name Desc Year
Type IT Project A Project A Desc 2011
Type Non IT Project B Project B Desc 2012
Type IT Project C Project C Desc 2013
Type IT Project D Project D Desc 2014

Client Client Z Project A Project A Desc 2011

Client Client X Project B Project B Desc 2012
Client Client Z Project C Project C Desc 2013
Client Client X Project D Project D Desc 2014

So according to the schema above, i want to pivot based on type and client colums. How can I do this?

Thanks in Advance.

Kind Regards.

Re: Pivot several columns to row

TRF — Tue, 21 Jan 2020 18:52:39 GMT

1 tMap with 2 output dedicated (type/client) flows each connected to a tHashOutput (append mode + linked).
OnSubJobOk you should have all the desired rows accessible using a tHashInput.
If tHashInput doesn't contain all rows, use 2 different (unassociated) tHashOutput then OnSubJobOk, 2 tHashInput each associated to the corresponding tHashOutput and connected to a tUnit.
Should work.

Re: Pivot several columns to row

TRF — Sat, 25 Jan 2020 20:25:53 GMT

Thanks for Kudo.
Don't forget to mark your case as solved if this answer help you to find a solution.