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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
dwighttrumbower
Creator
Creator

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
Creator
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

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