Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
ResultsFinal:
LOAD
OrderLine#,
Results.Customer as Final.Customer,
Results.DataSKU as Final.DataSKU,
ApplyMap('PRO_Mapping',Results.DataSKU,'NO MATCH') as Final.PRO, //NEW ADDITION
Results.QtyUnAll as Final.QtyUnAll,
Results.DateRequest as Final.DateRequest,
Results.LWHS as Final.LWHS,
Results.OrderCategory as Final.OrderCategory,
Results.Channel as Final.Channel,
Results.BU as Final.BU,
Results.Class as Final.Class,
if(Results.DateShip-Results.DateRequest<=0,'on time',
if(Results.DateShip-Results.DateRequest<=1 and wildmatch(CUSTSHIPTO, '30070-4' , '30070-43', '30070-63' , '30070-73' , '30070-163' , '30070-263' , '30071-4' , '30071-63' , '30072-4' , '30072-63' , '30073-4' , '30073-63' , '30074-4' ,'30074-13' , '30074-313' , '30070-3' , '30070-4' )>0, 'on time',
if(Results.DateShip-Results.DateRequest<=2 and wildmatch(CUSTSHIPTO, '30070-4' , '30070-43', '30070-63' , '30070-73' , '30070-163' , '30070-263' , '30071-4' , '30071-63' , '30072-4' , '30072-63' , '30073-4' , '30073-63' , '30074-4' ,'30074-13' , '30074-313' , '30070-3' , '30070-4' )>0 , 'plus 1',
if(Results.DateShip-Results.DateRequest=1,'plus 1','delayed')))) as Final.DelayClusterSHP,
ResultsFinal:
Can you post more information. The code you posted isn't complete.
Hi, could you please attached some sample data or be a little bit more specific on your problem?.
So far I understand that your field CUSTSHIPTO is not recognized. This could be for a lot of reasons, from misspelling to the field not included on the data source.
Best regards,
Andrés