topic Re: Applymap in QlikView

Applymap

prabhas277 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have Two tables T1 and T2. T1 contains 5 fields and t2 contains 5 fields now i want do the apply map for these 2 tables. In this case apply map is possible? IF possible How we can do it?

Thanks in advance

prabhas

Re: Applymap

Anonymous — Wed, 20 Jul 2016 07:52:10 GMT

Applymap table can support Two fields only in reference table.

Re: Applymap

Anonymous — Wed, 20 Jul 2016 07:52:24 GMT

Hi, have you thought about concatenate as an option?

Re: Applymap

Digvijay_Singh — Wed, 20 Jul 2016 07:58:01 GMT

Applymap can help you to pull fields from table T1 to Table T2 or vice versa only in case you have few common fields between them.

So you would create map tables first ( I assume you are aware that map table can have only two fields), the first field will be the lookup field( common between both tables) and the second field is the desired field needed to move between tables based on the matching values of the lookup field.

Example -

Map_productPrice:

Mapping LOAD productId,

stdPrice

FROM

[..\QVD\Product.QVD]

(qvd);

in fact table, we can pull stdPrice from above map table for the matching productId.

productId,

unitsSold*Applymap('Map_productPrice',productId) as [# Sales Amount],

Re: Applymap

prabhas277 — Wed, 20 Jul 2016 08:20:54 GMT

Thanks for sharp response.

can give explain the same with suitable example ..?

Re: Applymap

Digvijay_Singh — Wed, 20 Jul 2016 08:30:18 GMT

You have one table having Country Code, Country Name, Country Desc

Another table, a fact table, you can call as sales having country Code in each row.

You want to create country name in sales table using mapping table, using the first table. Also you want to show 'Unknown' in case country is not available in map table. You can do it like below -

Map_Country:

Mapping load

[Country Code],

[Country Name]

Resident Country table;

Sales:

.....( Other fields)

.....

[Country Code],

Applymap('Map_Country',[Country Code],'Unknown') as [Country Name] //Here you are pulling country name in //sales table

From

Sales source file;

Re: Applymap

Wed, 20 Jul 2016 08:35:24 GMT

using apply map you can get only one field not more than that....prabhas277

Re: Applymap

qlikview979 — Wed, 20 Jul 2016 08:38:39 GMT

Hi ,

If you want to apply map,take resident Two to fields from T1.

Ex:-

T1:

Load

Country Code,

Country Name,

Country Sales...

from.......;

T2:

mapping load

Country Code,

Country Name

resident T1;

T3:

mapping load

Country Code,

Country Sales

resident T1;

Drop Table T1;

Regards

Re: Applymap

tyagishaila — Wed, 20 Jul 2016 09:06:00 GMT

Depends on your requirement. Applymap can fetch single field value at a time.