Mappind load from a table (in one and only step)

[alexantone]

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);

[Colin-Albert]

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

[satishkurra]

Mapping Load has to be preceded to the existing load script.

USe Map Load 1st

AND

Then LOAD Statement

[Colin-Albert]

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