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

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
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