Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi *,
I'm trying to map to fields and I'm getting an $orphan field. I never got this before. Has someone an idea why this is
happening?
My code:
applymap('bnr',%BeID,'-') AS bxnr,
bnr:
Mapping LOAD
%BeID,
bxNR AS bxNR
FROM.....
The tables are currently already linked via %BelID.
Regards
Aloah
-> found the problem: loading from qvd!!
Actually that's the only official solution.
QV says you can never make a mapping load form a qvd. The work-around is to do as Aloah suggests or an undocumented solution as Jonas suggests.
I always err on the side of caution & chose to load mapping from a resident table and never from a qvd directly.
That's fine but there is nothing that I can find in their documentation that tells you not to use MAPPING / APPLYMAP from a QVD. Would certainly have saved me a lot of headaches / time!
Thanks a lot the WHERE 1=1 was the right solution for me! But agree, nothing in the help...
I am also glad I found this as it was causing me grief.
Agree that QlikView Help contents could more closely match the pdf version of the reference manual.
But I just did a search and it is present in the pdf:
page 319 of v9 reference manual
page 327 of v10 reference manual
********
Note Mapping load does not support the use of QVD files as input source. The
QVD must first be loaded to a table and then a mapping load can be made
from this table.