Add a Group list to all rows

Hi …

Is there a way for me to add a list (output from a GroupBy node) to every row in a dataset?

I tried to do it by making the list a variable and then using a Constant Value Column node to insert it but the node does not accept the variable as an input option.

I also tried using the Collection to String node to convert the list to a string but then how do I do the reverse to change the string back to a list?

Surely there is a simple way to do this?

tC/.

Hi @TigerCole,

you can Filter for the row with the list column (or if the GroupBy results in one row then you can skip that) and then use the cross joiner

5 Likes

Hi @AnotherFraudUser

Brilliant … thanks for “so simple” solution.

tC/.

2 Likes

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