Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community
Is there an another way to do it without makes two steps
OLEDB CONNECT32 TO ...
TableMapping1:
load
xxxxx&'@'&yyyyyy&'@'&zzzzzz as MY_KEY,
myfield ;
sql select *
FROM `Table`;
STORE 'TableMapping1' INTO [$(DataPath)TableMapping1.qvd] (QVD);
MapContrat1:
Mapping load
MY_KEY,
NOUV_CONTR
from [$(DataPath)TableMapping1.qvd]
(qvd);
The applymap command has a third parameter that is used when no match is found in the mapping table, this can be very powerful.
The example script you posted only shows the creation of the mapping table and not where the apply map is used.
For more details on using applymap look at this post Don't join - use Applymap instead
Mapping Load has to be preceded to the existing load script.
USe Map Load 1st
AND
Then LOAD Statement
If your question has been answered, please mark the correct answer and any helpful answers as this will help other users who come across this post in the community.
Thanks