topic Re: Group by clause only works when using all dimensions in App Development

Group by clause only works when using all dimensions

ingo_lsg — Sat, 16 Nov 2024 05:50:29 GMT

The following load statement doesn't work, when not using all of the loaded dimensions. (here in this example I didn't use TYPE_OF_SVC.

Any idea?

Load
    KEY_Ausland,
    PERIODE_NR_ROW,
    CARRIER_ALN_CD_ROW,
   TYPE_OF_SVC,
    SUM(CAP_FST_AMT+ CAP_BSN_AMT+ CAP_PEC_AMT+CAP_ECO_AMT ) as SEATS_TTL_NR_ROW,
sum(STARTS_TTL_NR_ROW) as STARTS_TTL_NR_ROW
Resident Nachfrage_Angebot_Temp
Group by KEY_Ausland,PERIODE_NR_ROW, CARRIER_ALN_CD_ROW;
//,TYPE_OF_SVC;
Drop Table Nachfrage_Angebot_Temp;

Re: Group by clause only works when using all dimensions

Gysbert_Wassenaar — Tue, 14 May 2019 15:25:08 GMT

If you use a GROUP BY then all the fields that are not used in aggregation functions (like sum) must be included in the GROUP BY clause. So a field is either in the GROUP BY or used in a sum/count/max/min (or any other aggregation) function.

Re: Group by clause only works when using all dimensions

ingo_lsg — Tue, 14 May 2019 15:38:14 GMT

So, when I want to add additional fields I would have to do this in a second resident load?