topic Error when using SUM and GROUP BY in sqript in App Development

Error when using SUM and GROUP BY in sqript

magnusrydberg — Fri, 23 Feb 2018 11:38:43 GMT

I am running this sqript using SUM and GROUP BY function in a load statement:

LOAD

StringKey1 as ContLONumber,

StringKey4 as ContSequence,

Status as ContStatus,

Sum("Time") as ContLogTime

Group By StringKey1;

SQL SELECT * FROM "MyL_PROD_220".OTSDATA.TimeLog where StringKey6='CONT';

When executing the sqript I'll got the error message "invalid expression"

What is not correct in my sqript?

jonathandienst — Fri, 23 Feb 2018 11:43:36 GMT

If you use a Group By, ALL the non-aggregated fields must be in the Group By list. So this should work

LOAD

StringKey1 as ContLONumber,

StringKey4 as ContSequence,

Status as ContStatus,

Sum("Time") as ContLogTime

Group By StringKey1, StringKey4, Status;

SQL SELECT * FROM "MyL_PROD_220".OTSDATA.TimeLog where StringKey6='CONT';

magnusrydberg — Fri, 23 Feb 2018 12:00:15 GMT

Thanks a lot Jonathan! Now it works and I understand the "Group By" statement