Transpose and pivote table

I want to transpose my table per Id and also If I haven’t value replace it with 0. e.g.

sdf

to:

weg

Can you confirm that your output table really should have a 0 in the last row for column4?

My suggestion is to:

Start with a GroupBy node. Group on your ID column and aggregate on column2 using “List (sorted)”.

Follow this with a Split Collection Column node to split the list you just created into separate columns.

Finish with a use a Missing Value node to replace missing values with 0.

5 Likes

@elsamuel thank you very much :smiley:

Hello -

Looks like this topic is a duplicate of this one:

You have solutions provided in both - which is great! - but please refrain from creating multiple topics about the same issue, so we can keep the forum tidy. :slight_smile:

Thank you!

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.