Cacher is the code snippet organizer for pro developers

Sales:
LOAD *,
IF(OntimeLateFlag =1, Dual('OnTime',1),
IF(OntimeLateFlag =2, Dual('SlightDelay',2),
Dual('Late',3))) As Flag
RESIDENT SalesTemp1;
DROP Table SalesTemp1;