How to do aggregate text with comma

prashant · August 25, 2023, 1:43am

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)

Anonymous · August 25, 2023, 7:59am

Hi,

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

Transform File.
HowtoAggregate.transform (1.7 KB)

prashant · August 25, 2023, 8:31am

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