How to do aggregate text with comma

Hellos All,

I have a table

  • Condition is to aggregate when Supplier+Color is same - Done by Concat Column (Col1-Col2)
  • Output if different values with text with “comma” - How to? (Col 3,4) ?
  • Output if different values with number with “sum” - Done by Sum (Col 5)


Set the setting for the Unique Transform as follows to get your desired result.

Transform File.
HowtoAggregate.transform (1.7 KB)

1 Like

Thank you for taking time to reply and give an example. I appreciate it