Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
vanderson009
Creator III
Creator III

ApplyMap Issue in Qlik Sense

I have following script, I have created mapping table to map M_STATUS against SYSTEM field from Table2 but i am not able to map it.

Please let me know if their is any wrong with script.

M_STATUS:

Mapping

Load      'AB' as SYSTEM

               M_STATUS

FROM Table1;

DATAMODEL:

Load    *, Applymap('M_STATUS',SYSTEM,null()) as STATUS;

Load     VENDOR,

             PO_ORDER,

             'AB' as SYSTEM            

FROM Table2;

Thanks,

Villyee.

11 Replies
marc_behrens
Partner - Contributor III
Partner - Contributor III

Well, probably his M_STATUS is Null(), who knows

kaanerisen
Creator III
Creator III

Yes, I think that is the case. Most probably first record of M_STATUS is null