topic Re: Is there a currently functioning tUnPivot component? in Talend Studio

Is there a currently functioning tUnPivot component?

fjblau — Fri, 15 Nov 2024 22:15:59 GMT

None of the UnPivot components on Exchange load into the Palette in Studio 8.

What I am looking to do:

Input Table:

Key Clubs

1 20,30,MM

2 40, BB

Output desired:

Key Club

1 20

1 30

1 MM

2 40

2 BB

But I can't seem to find a built-in component to do that.... other than converting the first Clubs to JSON and parsing it out that way.

Thoughts?

Re: Is there a currently functioning tUnPivot component?

Roberto72543 — Mon, 19 Dec 2022 12:29:13 GMT

The most basic example would be:

tFileInputDelimited -> tUnpivotRow -> tFileOutputDelimited

Connect the 3 components together in that order, and configure the file input and file output accordingly - ensure that you set up the schema for the file input and then cascade it through to the tUnpivotRow.

Now click the tUnpivotRow component and view the component configuration tab.

Under the Row Keys area, add all the columns that you want to remain fixed.

More info is here: https://community.talend.com/s/question/0D53p00007vCoPLCA0/resolved-unpivot-talend-component-question?language=en_US/NextEmployeePortal

Thanks,

Re: Is there a currently functioning tUnPivot component?

fjblau — Tue, 20 Dec 2022 07:49:02 GMT

tUnPivotRow is not supported in Studio v8 as far as I can tell.

I was able to do this with the built-in tNormalize component.