map using

[t_vijay_qlik]

Hi All,

can any one help with the following below code map using in qlikview

tab3:

Mapping load null(),'Null_Value' AutoGenerate 1;
map 'product','cost' using tab3;

tab4:

load * Inline [
sno,product,cost
1,a-101,100
2,  ,200
3,a-102,300
4,a-103,
5,  ,
];

i got the following  output

1,a-101,100
2,  ,200
3,a-102,300
4,a-103,
5,  ,

[rwunderlich · Accepted solution]

Firstly, when you specify fieldnames in a MAP USING, the fields should be specified using double quotes or brackets, not single quotes. So:

map "product", "cost" using tab3;

or

map [product], [cost] using tab3;

Since your field names don't contain quotes, the brackets/quotes are optional. You could write it as:

map product, cost using tab3;

Second, you will not find a match in the mapping table because you cannot generate a null in INLINE data.  Skipping over the field with the double comma will not generate a true null, but rather a blank field. 

-Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com