Convert 2D table to cross-table

[Anonymous]

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?

[Anonymous]

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

[Anonymous · Accepted solution]

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 🙂