Aggregate the column in one row level

Question & Answer
, ,
1

Is there any way to aggregate the column into single rows using comma separated values. For instance, we can use aggregation on Sql like this:

LISTAGG (measure_expr [, 'delimiter']) WITHIN GROUP 
(order_by_clause) [OVER query_partition_clause]

Screen Shot 2022-08-12 at 14.23.25
Screen Shot 2022-08-12 at 14.23.25892×312 46.9 KB

The same type of calculation I want in QuickSight. What I want is that I want Dx #2 ICD10 all filed to be aggregate into single row as C50.811, C50.811,Z51.11

Please suggest possible solution. Will appreciate any suggestions.

2

As of now we do not support this. The workaround is for you to manipulate the dataset before ingesting it in Quicksight.