trying to use a group by in load editor max()

[danaleota1]

Hello I'm trying to return only the max values from the column MOD_DATE grouped by my key.  Here is my script but I am getting an invalid expression when I try to run. 

TEMP:
LOAD
ACTIVITY_DATE,
MUID as SCHED_MUID,
//AGENTDATA,
EXCEPTION,
MINUTES,
MINUTES/60 as Minutes1,
TVID,
num(MODIFY_DATE) as MOD_DATE,
num(TVID) & '|' & date(floor(ACTIVITY_DATE)) as KEY_IdDate
FROM [some.qvd]
(qvd)
where SCHED_DATE >= '2019-09-01'
;

TOTAL_VIEW_AGENT_SCHE_DTL:
Load
KEY_IdDate,
max(MOD_DATE) as Max_Mod,
Minutes1
Resident TEMP
Group BY KEY_IdDate;

DROP TABLE TEMP;

[Taoufiq_Zarra]

try to remove Minutes1 from the

TOTAL_VIEW_AGENT_SCHE_DTL:

script's

[danaleota1]

The script runs when I remove Minutes1 however I still need this field.  It's actually the measure I need.  "max(MOD_DATE) as Max_Mod"  I know I used an aggregate function but this is actually a dimension where I only need returned is the record that has the highest value of the MOD_DATE.  

[Taoufiq_Zarra · Accepted solution]

Maye be :

TEMP:
LOAD
ACTIVITY_DATE,
MUID as SCHED_MUID,
//AGENTDATA,
EXCEPTION,
MINUTES,
MINUTES/60 as Minutes1,
TVID,
num(MODIFY_DATE) as MOD_DATE,
num(TVID) & '|' & date(floor(ACTIVITY_DATE)) as KEY_IdDate
FROM [some.qvd]
(qvd)
where SCHED_DATE >= '2019-09-01'
;


TOTAL_VIEW_AGENT_SCHE_DTL:
noconcatenate
Load
KEY_IdDate,
max(MOD_DATE) as Max_Mod
Resident TEMP
Group BY KEY_IdDate;
left join
load * resident TEMP;


DROP TABLE TEMP;