Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
HamidFOUNAS
Contributor
Contributor

Max(date) , GROUP BY INVALID EXPRESSION

Hello ,
please, I want to load the maximum of date_reelle   group by service demande_service but I have a message erreur , 

invalid expression 

thank you for helping me

 

 

LOAD demande_service,
max(date(date_reelle)) as datep;

[affectation_traitement_3]:
SELECT
date_reelle,
`demande_service`
FROM app.`affectation_traitement`
GROUP BY demande_service;

Labels (1)
1 Reply
BrunPierre
Partner - Master
Partner - Master

[affectation_traitement_3]:

LOAD demande_service,
max(date(date_reelle)) as datep

GROUP BY demande_service;

SELECT
date_reelle,
`demande_service`
FROM app.`affectation_traitement`;