Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Reload cannot identify the field

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:

Tags (2)
2 Replies

Re: Reload cannot identify the field CUSTSHIPTO

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


talk is cheap, supply exceeds demand
andrespa
Valued Contributor

Re: Reload cannot identify the field CUSTSHIPTO

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

Community Browser