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: 
Anonymous
Not applicable

Field not Found

Hi guys,

i am creating a new filed called Survey? (in the script editor) based on the following condition:

if( A > B, 'Survey', 'No Survey') as [Survey?],


The problem is that field B is not in the source data but I am mapping it using MAPPING LOAD/APPLYMAP.


Sense gives me the error that Field B cannot be found.


Is there a solution to this?


1 Solution

Accepted Solutions
shraddha_g
Partner - Master III
Partner - Master III

try

LOAD

   ApplyMap('SurveryLimit',"Claim To Code",'#N/A') as "Survey Limit ($)",   

   Region,

   Subs,

   "Claim No.",

   "Claim To Code",

   Amount,

    if("Amount" >ApplyMap('SurveryLimit',"Claim To Code",'#N/A'), 'Survey', 'No Survey') as [Survey?]

   

FROM [Table.xlsx];

View solution in original post

8 Replies
agigliotti
Partner - Champion
Partner - Champion

please post the entire script to help you.

prma7799
Master III
Master III

Please share your script ...

shraddha_g
Partner - Master III
Partner - Master III

Share a screenshot of your script

Anonymous
Not applicable
Author

This is the current script:

LOAD

   ApplyMap('SurveryLimit',"Claim To Code",'#N/A') as "Survey Limit ($)",   

           

   Region,

   Subs,

   "Claim No.",

   "Claim To Code",

   Amount,

   

  

    if("Amount" > "Survey Limit ($)", 'Survey', 'No Survey') as [Survey?],

   

FROM [Table.xlsx];

shraddha_g
Partner - Master III
Partner - Master III

try

LOAD

   ApplyMap('SurveryLimit',"Claim To Code",'#N/A') as "Survey Limit ($)",   

   Region,

   Subs,

   "Claim No.",

   "Claim To Code",

   Amount,

    if("Amount" >ApplyMap('SurveryLimit',"Claim To Code",'#N/A'), 'Survey', 'No Survey') as [Survey?]

   

FROM [Table.xlsx];

shraddha_g
Partner - Master III
Partner - Master III

also check whether applymap is giving any value in return

agigliotti
Partner - Champion
Partner - Champion

try with the below script:

LOAD *,

if("Amount" > "Survey Limit ($)", 'Survey', 'No Survey') as [Survey?];

LOAD

   ApplyMap('SurveryLimit',"Claim To Code",'#N/A') as "Survey Limit ($)",  

          

   Region,

   Subs,

   "Claim No.",

   "Claim To Code",

   Amount

  

FROM [Table.xlsx];

sumanta12
Creator II
Creator II

Try using the below script:

TAB1:

LOAD

   ApplyMap('SurveryLimit',"Claim To Code",'#N/A') as "Survey Limit ($)",  

          

   Region,

   Subs,

   "Claim No.",

   "Claim To Code",

   Amount

  

FROM [Table.xlsx];

TAB2:

LOAD

if("Amount" > "Survey Limit ($)", 'Survey', 'No Survey') as [Survey?],

"Survey Limit ($)",  

Region,

    Subs,

   "Claim No.",

   "Claim To Code",

    Amount

   

RESIDENT TAB1;

DROP TABLE TAB1;