Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need Where Max Filed ' CreateDate'
MaxDate:
Load
max(CreateDate) as MaxCreateDate
From [xyz.qvd](qvd);
let vMaxCReateDate=peek('MaxCreateDate',0,'MaxDate');
Drop table MaxDate;
MainTable:
load
a,
b,
CreateDate,
d,
e
From [xyz.qvd](qvd) where CreateDate='$(vMaxCReateDate)';
Regards,
Aditya
I tried but the data is not showing.
Check if the field date format is same as date format in variable.
If that doesn't work ,please share sample data ? You can jumble the numbers if you want.
Regards,
Aditya