[resolved] Pivot Table with multiple rows

One Star

[resolved] Pivot Table with multiple rows

Get getting started with Talend and looking for a bit of guidance and an approach to do the following...
DB Table Structure
Team |  Value | ValueType                                                                  Team  |  Score1 | Score2 | Score3
1            2.2       Score1                                                                        1           2.2        3.2        3
1            3.2       Score2                                                                        2           1.1         2          5
1            3          Score3                 Trying to transform to ---------> 
2            1.1       Score1
2            2          Score2
2            5          Score3
Thanks!
D

Accepted Solutions

Re: [resolved] Pivot Table with multiple rows

This is actually pretty easy in Talend -- if you've done it before Smiley Happy
To do this kind of pivot, you're going to use two components together: "tDenormalize" and "tExtractDelimitedFields"
the tDenormalize will flatten your original data into two rows -- one for each team. Then we use tExtractDelimitedFields to break the data into the score1..score3 columns.
Please see the screenshots below. Please let us know if you have any more questions, or if this is not clear. 


All Replies

Re: [resolved] Pivot Table with multiple rows

This is actually pretty easy in Talend -- if you've done it before Smiley Happy
To do this kind of pivot, you're going to use two components together: "tDenormalize" and "tExtractDelimitedFields"
the tDenormalize will flatten your original data into two rows -- one for each team. Then we use tExtractDelimitedFields to break the data into the score1..score3 columns.
Please see the screenshots below. Please let us know if you have any more questions, or if this is not clear. 

Four Stars

Re: [resolved] Pivot Table with multiple rows

emang bener ya Talend banyak di pakai untuk Big Data ???