topic Re: Convert 2D table to cross-table in Talend Studio

Convert 2D table to cross-table

Anonymous — Thu, 25 Apr 2019 10:27:32 GMT

I just would like to convert a 2D table (something like "list of registers")

field1 field2 value

...

SX 805 4
SX 806 9
SX 807 5
SL 805 2
SL 806 3
SL 807 6
...

to a cross-table

SX SL

... ... ...

805    4    2
806    9    3
807    5    6

... ... ...

Is it possible using Talend?

Re: Convert 2D table to cross-table

Anonymous — Fri, 26 Apr 2019 06:31:31 GMT

Hello,

With your job requirement, you can use component tPivotToColumnsDelimited to convert rows to columns.

For more information, please have a look at this component reference about:TalendHelpCenter:tPivotToColumnsDelimited.

Best regards

Sabrina

Re: Convert 2D table to cross-table

Anonymous — Fri, 26 Apr 2019 07:15:50 GMT

Hi,

Below are the component details.

Output is as shown below.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂