Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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, ,
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
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