Apply Map for Composite Key

[vikasmahajan]

Dear All

I have following tables

Table1 (Ratemaster)

Product Code

Batch No

NBR 

Table2 ( Batch Master)

product Code

Bath No

How to give appy map command for  ( Product Code + Batch No ) key combination.

Thanks

Vikas

[#2]

try on this

Table1:

[Product Code] &'-'& [Batch No] as key,

[Product Code],

[Batch No],

NBR

from Table1;

Table2:

[Product Code] &'-'& [Batch No]  as key,

[Product Code],

[Bath No]

from Table2;

[tresesco]

map1:

mapping load

                   [Product Code]&[Batch No] as X,

                   Y      

From <>;

Then Something like:

Load

ApplyMap ('map1',   [Product Code]&[Batch No] ) as Mapped

[jagan]

Hi,

Concat the two strings (Product Code &  Batch No) and use the Mapping Load and ApplyMap() asusual.  The mapping Load table should contain only two columns.

RoomMaster:

Mapping LOAD

Product Code & Batch No AS Key,

NBR 

FROM Datasource1;

BatchMaster:

LOAD

Product Code,

Batch No,

ApplyMap('RoomMaster', Product Code & Batch No) AS NBR 

FROM Datasource2;

Hope this helps you.

Regards,

jagan.

[#5]

example:

ApplyMap('Ratemaster', [Product Code] &'-'&[Batch No], 'Unknown') as NBR

I dont know if it works, but try