How to solve this problem...


I have a table like this:

x 0
x 1
y 3
y 2
z 1
z 2

I need an output like this:

x y z
0 3 1
1 2 2



Group by A, Aggregation on B (as sorted List)

Row ID Node (use column A as new RowID)

split collection column (on List of B Column)


Cheers, Iris

You are my god =)

If you do not mind installing 3rd party -recently not updated- extensions, you might give try to the Pivot node from HiTS. It seems it fits your use case quite well. (It has some quirks, but had similar tables a lot at that time, so I thought this might be useful for others too.)

Cheers, gabor