Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
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;