Concat and Group by Error

[AlexWest]

Hi guys!

Could you please help with concationation of text and making a Group by func?

I have the following script, but there is always an error below:

SMS_mar1:
LOAD
ID,
INSERT_DATE,
"TEXT"
FROM [lib://path/workbook.xlsx]
(ooxml, embedded labels, table is [Sheet 1]);

mini_SMS_mar1:
Load
ID,
INSERT_DATE,
Concat(TEXT) as Text
Resident SMS_mar1
Group By ID;

[BrunPierre · Accepted solution]

Non-aggregated fields must be listed in the group by clause, in your case the 'INSERT_DATE' field

or perhaps aggregate like this;

Max(INSERT_DATE) as INSERT_DATE

[AlexWest]

Thanks a lot!
I didn't know that I need to Group by other non-aggregated fields. In all tutorials there were no such mentions about it.