String Aggregation Type - Distinc String Concatenate
Posted: Mon May 13, 2024 11:34 pm
Hi,
writing some reports which involves aggregating data sets which have numeric and string values. The requirements are to aggregate the data into groups for the numerics using sum/avg styles however with the string data types the only options are first/last/count/count(distinc). It would be handy to have an aggregation style called "Distinc String Concatenate". This would work similarly to the SQL function STRING_AGG but only return the distinc strings with a seperator as a single string. This would allow you to show all the string values in a single row when aggregating.
https://learn.microsoft.com/en-us/sql/t ... rver-ver16
Regards,
Brett
writing some reports which involves aggregating data sets which have numeric and string values. The requirements are to aggregate the data into groups for the numerics using sum/avg styles however with the string data types the only options are first/last/count/count(distinc). It would be handy to have an aggregation style called "Distinc String Concatenate". This would work similarly to the SQL function STRING_AGG but only return the distinc strings with a seperator as a single string. This would allow you to show all the string values in a single row when aggregating.
https://learn.microsoft.com/en-us/sql/t ... rver-ver16
Regards,
Brett