Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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:

2 Replies
Gysbert_Wassenaar

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


talk is cheap, supply exceeds demand
andrespa
Specialist
Specialist

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