2 Replies Latest reply: Jan 18, 2016 3:47 PM by sneha jha RSS

    Reload cannot identify the field

    sneha jha

      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: