Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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-questio.../NextEmployeePortal
Thanks,
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.