Pivot Node show multiple entries

[Mink]

Hi there,

how is it possible to show more entries in a separate row?
For example this is the input table for the pivote node.

Table
ID Val1 Val2
1 A 99
1 B 93
1 C 90
1 A 71
1 B 72
1 C 74
2 A 33
2 B 33

I want this as a result:
ID A B C
1 99 93 90
1 71 72 74
2 33 33

Do you see the ID 1 has two entries, how do I solve this?

[ipazin]

Hi there!

In Pivoting node use Aggregation method List and after that use Ungroup node. That should do the trick

Br,
Ivan