Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I guys, I have this line of code:
Load
max(Data) as maxDate
Resident Calendar ;
Let vMaxDate = Date($(varMaxDate));
DROP Table Temp;
Table:
LOAD id
MakeDate(year, month, day) as DateTb,
effort
FROM
[path ...]
(ooxml, embedded labels, table is xtmp);
TableDate:
LOAD *
Resident Table
where DateTb > $(vMaxDate);
The last part of the script (TableDate) doesn't work, and load all date.
Someone can tell me why the "where" clause doesn't work?
Thanks
May be the where condition is as below:
where DateTb > $('vMaxDate'); <-- see the single quote within the bracket
where DateTb > $('vMaxDate');
Are the fields in the same format??
How do you define varMaxDate?
Hi guys, I resolved in this way:
Where Date(DateTb) > '$(vMaxDate)';