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

Announcements
Posting on Qlik Community is temporarily paused. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
dwighttrumbower
Creator II
Creator II

Can you have two loads in a mapping statement?

I have a current mapping statement that I also need to add a single record to it.  What is the best way to do that?

current working code: 
SalesRepRegionMap:
MAPPING LOAD DISTINCT
CurrentSalesRepNumber AS RepNumber,
SalesRegion
RESIDENT ProductSales;

 

Would need to add 

LOAD * INLINE

[RepNumber, SalesRegion

17, West

];

 

Thanks

Labels (3)
3 Replies
dwighttrumbower
Creator II
Creator II
Author

This is what I'm trying.

SalesRepRegionMap:
MAPPING LOAD DISTINCT
CurrentSalesRepNumber AS RepNumber,
SalesRegion
RESIDENT ProductSales;
LOAD * INLINE
[CurrentSalesRepNumber, SalesRegion
17, West];

It doesn't fail, but I don't believe it is doing what I want.

anat
Master
Master

why are you using resident load ?

SalesRepRegionMap:
MAPPING LOAD DISTINCT
CurrentSalesRepNumber AS RepNumber,
SalesRegion;
LOAD * INLINE
[

CurrentSalesRepNumber, SalesRegion
17, West

];

marcus_sommer
MVP
MVP

In general it's possible - but it has some restrictions and is therefore not always applicable respectively practicably. See more here: Can I Update a Mapping Table? | Qlikview Cookbook