Dear all,
I've been playing with table pivoting for a long time but in other apps than Pipeline. What I often use and need is a multiple columns pivoting. For example :
A | B | C | D | E |
---|---|---|---|---|
1 | 1.1 | 10 | Y | AA |
2 | 2.1 | 20 | Y | AA |
1 | 1.1 | 30 | N | AA |
2 | 2.1 | 40 | N | BB |
1 | 1.1 | 50 | Y | BB |
2 | 2.1 | 60 | Y | CC |
would give as an output of the pivot :
A | B | Y+AA | N+AA | Y+BB | N+BB | Y+CC |
---|---|---|---|---|---|---|
1 | 1.1 | 10 | 30 | 50 | 60 | |
2 | 2.1 | 20 | 40 |
I tried the Pivot data component trying to put more than one Pivot Name and Pivot value but it does not work. Has anybody some experience with multi-column pivoting in Pipeline that could help ?
Thanks,
Jonathan.