Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I to load a min date from qvd?
// from qvd
MinMaxDate:
load
min(Date) as mindate, max(Date) as maxdate from Transactions.qvd (qvd);
// into var
let vMin=peek('mindate');
let vMax=peek('maxdate');
Same syntax as for any other source
Fabrice
// from qvd
MinMaxDate:
load
min(Date) as mindate, max(Date) as maxdate from Transactions.qvd (qvd);
// into var
let vMin=peek('mindate');
let vMax=peek('maxdate');
Min(Date) as MinDate