What are the challenges you face when working across database platforms? Take the survey
Options

string_agg not recognized as a grouping function

Running version 9.1.1.4243   
I had following code  

SELECT     TOP ( 50 ) cd.RPT_REC_NUM
                    , cd.component
                    , cd.sheet
                    , cd.cell_row
                    , STRING_AGG(
                          CASE WHEN cd.cell_col = '00200' THEN cd.ITM_VAL_ALPHA
                               ELSE NULL END) AS ccn
                    , STRING_AGG(
                          CASE WHEN cd.cell_col = '00100' THEN cd.ITM_VAL_ALPHA
                               ELSE NULL END) AS fname
                    , w.Tsheet
                    , w.Tline
FROM       cell_data AS cd
INNER JOIN wk_col0_map AS w
    ON cd.sheet = w.Ssheet
       AND LEFT(cd.cell_row, 3) = w.Sline
WHERE      cd.cell_col IN ( '00100', '00200' )
 
When I added a group by and selected "all non-aggregated columns"   prompt added the following 

 GROUP BY 
 STRING_AGG(CASE WHEN cd.cell_col = '00200' THEN cd.ITM_VAL_ALPHA
ELSE NULL END)
, STRING_AGG(CASE WHEN cd.cell_col = '00100' THEN cd.ITM_VAL_ALPHA
ELSE NULL END)
, cd.RPT_REC_NUM
, cd.component
, cd.sheet
, cd.cell_row
, w.Tsheet
, w.Tline

Apparently it did not recognize the string_agg function as grouping function as it would if I had specified SUM() 

Thanks for you product and support 

Tagged:
Sign In or Register to comment.