Reload cannot identify the field

Mon, 18 Jan 2016 17:34:04 GMT

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:

Re: Reload cannot identify the field CUSTSHIPTO

Gysbert_Wassenaar — Mon, 18 Jan 2016 17:42:42 GMT

Can you post more information. The code you posted isn't complete.

Re: Reload cannot identify the field CUSTSHIPTO

andrespa — Mon, 18 Jan 2016 17:42:50 GMT

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

topic Re: Reload cannot identify the field CUSTSHIPTO in QlikView

Reload cannot identify the field

Re: Reload cannot identify the field CUSTSHIPTO

Re: Reload cannot identify the field CUSTSHIPTO