Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

t_vijay_qlik
New Contributor III

map using

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,  ,

 

 

1 Solution

Accepted Solutions
MVP & Luminary
MVP & Luminary

Re: map using

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

1 Reply
MVP & Luminary
MVP & Luminary

Re: map using

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