topic Map..Using (mapping) fucntion Info please.. in QlikView

Map..Using (mapping) fucntion Info please..

Mon, 04 Jun 2012 01:26:36 GMT

Any one help me how to understand mapping function i.e Map Using?????

Map..Using (mapping) fucntion Info please..

marcohadiyanto — Mon, 04 Jun 2012 02:49:42 GMT

hi stalwart,

you can use googlemap to combine with your qvw, or using streetdirectory.

if you want detail please search in this community "google map"

regards,

marco

Map..Using (mapping) fucntion Info please..

Mon, 04 Jun 2012 03:06:12 GMT

Thanks Marco...

Map..Using (mapping) fucntion Info please..

Mon, 04 Jun 2012 03:22:09 GMT

Still i am not able to understand map using funtion..Please give me some link or video on this..

Map..Using (mapping) fucntion Info please..

Siva_Sankar — Mon, 04 Jun 2012 06:17:15 GMT

Try this link... http://community.qlik.com/qlikviews/1124

Re: Map..Using (mapping) fucntion Info please..

Miguel_Angel_Baeyens — Mon, 04 Jun 2012 07:26:35 GMT

Hi,

If you mean the use of MAPPING and USING in the script, please take a look at the following example. First, you need a mapping table, then you use the MAP sentence, and from then, all values in CountryCode will be changed for the matching in the mapping table. In the example, ES and US will be changed to "Spain" and "United States", while UK will stay (there's no match in the mapping table for that value).

CountryNamesMap:
MAPPING LOAD * INLINE [
ShortName, LongName
ES, Spain
US, United States
];
MAP CountryCode USING CountryNamesMap;
Data:
LOAD * INLINE [
CountryCode
ES
UK
US
];

Hope that helps.

Miguel

Map..Using (mapping) fucntion Info please..

Anonymous — Tue, 05 Jun 2012 08:09:51 GMT

Hi Miquel,

I personally would use applymap for your example. I've never used MAPPING and USING.

What's the fundemental difference between applymap and MAPPING and USING? They really appear the same 2 me.

Cheers!

iSam

Map..Using (mapping) fucntion Info please..

Anonymous — Tue, 05 Jun 2012 08:12:50 GMT

I think I found the difference. applymap needs 2 be used in each load, where as MAPPING and USING does not. is that correct?

Re: Map..Using (mapping) fucntion Info please..

Miguel_Angel_Baeyens — Tue, 05 Jun 2012 08:15:39 GMT

Hi,

Yes, that's right. Think of a data model where you have a lot of CountryID fields which values you want to rename in the whole data model. You would either use as many ApplyMap() functions as fields you want to change, or use MAP Field USING after the MAPPING LOAD.

Hope that makes sense.

Miguel

Map..Using (mapping) fucntion Info please..

Anonymous — Tue, 05 Jun 2012 08:19:20 GMT

Thanks a lot! that's very good practical example

Re: Map..Using (mapping) fucntion Info please..

stevedark — Wed, 15 Aug 2012 12:41:22 GMT

Hi Miguel,

Surely if you were modifying the value of every field with the same name in the load script it must by definition be a key field? If there is a key in play like that then I would have thought you would more likely have the text dimension in just one of the tables - rather than swapping the key out for a value in all of them?

I'm not sure there would be many circumstances where MAP ... USING would actually be useful - and certainly not worth the potential confusion in the code of a field being given a different value with no code obviously affecting it (in the same way as QUALIFY does - which often causes confusion).

Steve

http://www.quickintelligence.co.uk/

Re: Map..Using (mapping) fucntion Info please..

Wed, 05 Feb 2014 08:10:36 GMT

Hi, I'm trying to execute this mapping ... but it does not work ... the field 'Revenue_Type' always show the original values, (FOOD y BEV)

Thanks.

Rev_Type:

Mapping load * Inline
[food,Alimentos
bev,Bebidas];
map [Revenue_Type] using Rev_Type;
Rev_FB:
SQL SELECT
Revenue_Type,
FROM `C:\DIR\BBDD`.`Query_MDB`;

Re: Map..Using (mapping) fucntion Info please..

stevedark — Wed, 05 Feb 2014 10:15:09 GMT

Hi there,

With the example code you have posted only Revenue_Type of bev will be replaced, in this case for Bebidas.

If you are just looking for a single value to be replaced you may be wanting a replace statement?

Replace(Revenue_Type, 'BEV', 'Bebidas') as Revenue_Type,

Steve

Re: Map..Using (mapping) fucntion Info please..

Wed, 05 Feb 2014 10:24:06 GMT

Thanks Steve, but I'm looking for replace Revenue_Type field with the value "Bebidas" if the original value is 'Bev' or "Alimentos" in case the original value was 'Food'

Regards

José María

Re: Re: Map..Using (mapping) fucntion Info please..

stevedark — Wed, 05 Feb 2014 10:29:53 GMT

I see, the problem was with my Spanish!

The first line of an INLINE table is always the column headings, you want an extra row on the table:

Rev_Type:

Mapping load * Inline
[desde,a

food,Alimentos
bev,Bebidas];

That should then work. You may also need to be careful of the case of the characters though.

-Steve

Re: Map..Using (mapping) fucntion Info please..

Wed, 05 Feb 2014 10:43:34 GMT

Sorry, it does not work the code now is ...

Rev_Type:

Mapping load * Inline [
Short,Long
BEV, Bebidas
FOOD, Alimentos ];
map Revenue_Type using Rev_Type;

The result is ..

Regards

Re: Map..Using (mapping) fucntion Info please..

stevedark — Wed, 05 Feb 2014 10:56:42 GMT

You need to match the case of the fields:

Rev_Type:

Mapping load * Inline [
Short,Long
Bev, Bebidas
Food, Alimentos ];
map Revenue_Type using Rev_Type;

You may therefore need multiple lines in your mapping table to cater for a mix of case in your source data. You would get more flexibility if you used the ApplyMap statement (rather than Map Using) as you could then mix in Upper and Capitalize statements with the solution.

Steve

Re: Map..Using (mapping) fucntion Info please..

Wed, 05 Feb 2014 11:23:07 GMT

Now it works .... I've added Force case Mixed line ...

Thank you for your support ... and sorry for my English ....

Best regards

José María

Re: Map..Using (mapping) fucntion Info please..

stevedark — Wed, 05 Feb 2014 11:30:22 GMT

Glad it's now working. And don't worry, your English is a lot lot better than my Spanish!

Re: Map..Using (mapping) fucntion Info please..

adnan_rafiq — Thu, 17 Aug 2017 06:02:17 GMT

hi Steve, I have a supplementary question to the discussion please see the code below.

Rule_Key_Map:

Mapping

LOAD * INLINE [

Old_Value, New_Value

Rule-3, Rule-Z

Rule-4, Rule-A

];

MAP RuleXXX using Rule_Key_Map;

Test2:

Load

RuleXXX

From

[Test1.qvd](qvd);

//While Test1.qvd is this

Test1:

Load * Inline

[

RuleXXX,Rule_Key4

Rule-3,Rule-3

];

When I load this out of inline load the map works and changes the Rule-3 to Rule-Z,

But when i load out of QVD the map doesn't work.

You can store the Test1 inline table and give this code a try.