Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
why is here an error and how can i fix it?
regards,
Sam
TOTAL Qualifier is not available in the script... to do this, you can try this
Table:
LOAD sDate,
Product,
Number,
Store
FROM .....;
Left Join (Table)
LOAD Max(sDate) as Max
Resident Table;
FinalTable:
LOAD *,
If(sDate = Max, Number) as New_Number
Resident Table;
DROP Table Table;
Whats the error description in the console?