Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am getting the following error: Error: Field not found - <Date>
QUALIFY *;
GeoLocColSum:
LOAD REGION,
Floor(DATE) as Date,
"TOTAL_REQUESTS",
"PASSED_REQUESTS",
"FAILED_REQUESTS",
ISMAXDATE
Resident GeoLocColSumTemp Where Date>$(vMaxDate);
It is showing the same error even if I use Where GeoLocColSum.Date>$(vMaxDate);
I think this is because of Qualify.
Your help is appreciated.
Based on your preceding load, the "date" field is called "DATE" not "Date", so change the where clause to this:
Where DATE >$(vMaxDate);
Try not to create duplicate threads