Column aggregation to row concatenation

Hello,
I need to transform a table like depicted in the picture.
ā€”> kind of a concatenation of column elements into a row by another column element.
Does anybody know how I can achieve this - which node/combination of nodes should be used?

Column%20Aggregation

Hi!

One node (GroupBy) will be enough. Group column is your SessionID column and under Manual Aggregation chose SearchPhrase column and for aggregation function use Concatenate or Unique concatenate :wink:

Br,
Ivan

1 Like

Hi Ivan,

perfect! Thank you very much.
I need to learn a lot :slight_smile:

Cheers,
Philipp

1 Like

You are welcome :slightly_smiling_face:
Ivan

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