topic mapping load in QlikView

mapping load

Sat, 20 Jun 2009 23:07:36 GMT

I sold this product
item:
Load * Inline [

item,
AZ002
BZcode
LZ253
];

This is the master:

Load * Inline [

item , family
AZ002 , AA
BZcode, AA
LZ253, BB
C130, CC
STG25, DD
PP140, EE
MG250, FF
TR560,FF
];

Now, I woyld to serach in master and to extract the item and the family linked . I qoluld to create a new list box buld JUST the code thath
exists and not all the master table.
I know I qould to create a ma:
mapping load of master
after?

Thanks

Best regrds

mapping load

Anonymous — Sun, 21 Jun 2009 01:11:58 GMT

If you want to use mapping:


ItemFamilyMap:
mappind load distinct
item as A,
family as b
resident master;
...

join (item) load
item,
applymap('ItemFamilyMap', item) as family
resident item;

mapping load

Sun, 21 Jun 2009 02:22:04 GMT

Thnks. Yes, it works.

Please if i I put in a Master table an other field called division?

Load * Inline [

item , family, Division
AZ002 , AA , line
BZcode, AA, , line
LZ253, BB, , line
C130, CC, outline
STG25, DD, outline
PP140, EE,outline
MG250, FF, line
TR560,FFoutline
];

I know the mapping load require max 2 field.....

thanks

Regards,

Slash

mapping load

Anonymous — Sun, 21 Jun 2009 03:01:32 GMT

Correct, you cannot do it in one map, so it will be two:


ItemFamilyMap:
mappind load distinct
item as A,
family as b
resident master;

ItemDivisionMap:
mappind load distinct
item as A,
Division as b
resident master;
...

join (item) load
item,
applymap('ItemFamilyMap', item) as family,
applymap('ItemDivisionMap', item) as Division
resident item;

I don't know what exactly you want to achieve. Maybe consider using left join:


item:
 Load * Inline [

 item,
 AZ002
 BZcode
 LZ253
 ];

LEFT JOIN (item) Load * Inline [

 item , family, Division
 AZ002 , AA , line
 BZcode, AA, , line
 LZ253, BB, , line
 C130, CC, outline
 STG25, DD, outline
 PP140, EE,outline
MG250, FF, line
TR560,FFoutline
];

You'll get the same result. (As a rule, I use mapping if need to apply the same map in more than one place in the script.)