topic Re: Apply Map for Composite Key in QlikView

Apply Map for Composite Key

vikasmahajan — Thu, 29 Aug 2013 09:22:27 GMT

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

Re: Apply Map for Composite Key

Thu, 29 Aug 2013 09:26:43 GMT

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;

Re: Apply Map for Composite Key

tresB — Thu, 29 Aug 2013 09:28:16 GMT

map1:

mapping load

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

From <>;

Then Something like:

Load

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

Re: Apply Map for Composite Key

jagan — Thu, 29 Aug 2013 09:30:09 GMT

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.

Re: Apply Map for Composite Key

Thu, 29 Aug 2013 09:30:56 GMT

example:

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

I dont know if it works, but try