Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
why are you using resident load ?
SalesRepRegionMap:
MAPPING LOAD DISTINCT
CurrentSalesRepNumber AS RepNumber,
SalesRegion;
LOAD * INLINE
[
CurrentSalesRepNumber, SalesRegion
17, West
];
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