Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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