I want to transpose my table per Id and also If I haven’t value replace it with 0. e.g.
to:
I want to transpose my table per Id and also If I haven’t value replace it with 0. e.g.
to:
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.
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.
Thank you!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.