replace a field bast on the min date

[aitmessaoudali]

Hello community,

i want to to create dimension d in the screenshot, keeping only the id of the min(date) but also keeping all the lines and replacing the other ids by the id of the min date.

thanks in advance

[PrashantSangle]

where you want?? in front end or in script??
In front end you can try with firstsortedValue(value,-date)

Regards,
Prashant Sangle

[aitmessaoudali]

hello, i would prefer to implement it in the script. thanks

[PrashantSangle · Accepted solution]

Final:
Load A,
date,
c
From Table;
Left Join
Load A,
firstsortedvalue(c,date) as d
Resident Final
group by A;