Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
i would like to duplicate on each line of year the min (date) in an expression (see example)
Thanxx
Maybe you want add something like the following to your load script?
[Data]:
LOAD date,
year(date) as year
FROM [your\source];
[Tmp_Minimum]:
LOAD year,
Date(Min(date), 'DD.MM.YYYY') as minimum
RESIDENT [Data]
GROUP BY year;
LEFT JOIN([Data])
LOAD year, minimum
RESIDENT [Tmp_Minimum];
DROP TABLE [Tmp_Minimum];
hi Dorothea,
thanks but i don't want to modify my script ...
can't we put a calculated dimension in aggr ? like :
aggr(min(date),year(date)) (doesn't work for me)