topic Apply Map in QlikView

Apply Map

srinivasa1 — Wed, 16 Feb 2011 12:12:02 GMT

Hey any one has good example for apply map. as im first time using this feture

thx in advance.

Apply Map

srinivasa1 — Wed, 16 Feb 2011 12:20:13 GMT

Hey

Pls can any one explain me where the use of apply map?

Apply Map

Wed, 16 Feb 2011 12:36:21 GMT

Hi
Please go through example

-------------------------------------------------------------
map1:
mapping load * inline [

ID, Textvalue

1, one

2, two

3, three ] ;

ApplyMap ( 'map1', 1, 'xxx' ) It will return 'one'

ApplyMap ( 'map1', 2 ) It will return 'two'

ApplyMap ( 'map1', 4 ) It will return 4

ApplyMap ( 'map1', 5, 'No result' ) It will returns No result

---------------------------------------------------------------

Regards--

Nayan

Apply Map

Wed, 16 Feb 2011 13:27:13 GMT

Suppose you have two tables say Cutomer master and Sales, Now Customer Master table contain CustID, CustName

and Sales conatin CustID, Amt etc. Now if you want to find Customer Name wise sales then you can Use Applymap to find Customer name by usinf CutomerId

Regards--

Nayan

Apply Map

srinivasa1 — Wed, 16 Feb 2011 13:29:06 GMT

Hi Nayan

thx for reply

ApplyMap ( 'map1', 1, 'xxx' ) where i has to write in etl script or Experssion?

Apply Map

srinivasa1 — Wed, 16 Feb 2011 13:41:49 GMT

thx nayan once again.pls let me know where i can write this Apply map Script?

thx in advance.

Apply Map

Wed, 16 Feb 2011 14:30:33 GMT

you can write in application Script

Apply Map

srinivasa1 — Wed, 16 Feb 2011 14:58:31 GMT

Hi Im getting error.pls find beloow script any mistake in beloow script

LOAD

UniqueID

FROM

ABC.txt

(

txt, codepage is 1252, embedded labels, delimiter is '|', msq

)

where

UniqueID=15

;

map1:

mapping

load * inline

[

ApplyMap

( 'map1', 1, 'xxx' ) ;

thx once agin.

Apply Map

stevedark — Tue, 07 Jun 2011 22:18:58 GMT

Hi there,

I have just blogged on the many uses and the required syntax for the ApplyMap Statement:

http://bit.ly/kQcAZ5

Regards,

Steve

Re: Apply Map

Thu, 13 Oct 2011 05:49:35 GMT

i have a question....

in apply map statement it would return one, two ,or three as they are mentioned in inline above

like one for 1

two for 2

three for 3

n would return no result for 5 as its nt present in line while using applay map this is clear

thn why it would result 4 for 4???????

applymap('map1',4) returns 4 // how?????????

Re: Apply Map

Sokkorn — Thu, 13 Oct 2011 06:18:06 GMT

Hi Srinivasa,

Let take a look my script below:

[tmpData1]:
LOAD * INLINE [
F1,    F2
1,            100
2,            200
3,            300
4,            400
5,            500];
[Mapping1]:
MAPPING
LOAD * INLINE [
CusID,    CustName
1,    AA
2,    BB
3,    CC];
[TestApplyMap]:
LOAD
    F1    AS CustomerID,
    APPLYMAP('Mapping1',F1,'-')    AS CustomerName,
    F2    AS Amt
RESIDENT [tmpData1];
DROP TABLE [tmpData1]

Result:

CustomerID	CustomerName	Amt
1	AA	100
2	BB	200
3	CC	300
4	-	400
5	-	500

See more in attached file.

Hope this help you.

Regards,

Sokkorn

Apply Map

SunilChauhan — Thu, 13 Oct 2011 06:20:45 GMT

you can write mapping keyword and applymap in same table

ddo like below;

tamp:
mapping
load *
resident Employee_Mail;
drop table Employee_Mail;
Employees_new:
Load *,
ApplyMap('tamp',EmployeeID) as Email
resident Employees;
drop table Employees;

shipment_tamp1:
mapping
load *
resident Shipments;
drop Table Shipments;
Temp_Order_Detail:
Load *,
ApplyMap('Shipments','Order_Line_Key') as Email
resident OrderDetail;
drop table OrderDetail;

Re: Apply Map

stevedark — Thu, 13 Oct 2011 08:03:03 GMT

Hi Batra,

It comes down to the third optional parameter of ApplyMap. If this is omitted (as in the example for 4 above) then the value that is being used as the key is returned as the vaule where no match is found. If a third parameter is provided this then this is used in the case of no match being found (as in the example for 5 above).

I go into detail on this here: http://bit.ly/kQcAZ5

- Steve

Re: Apply Map

Thu, 13 Oct 2011 09:50:08 GMT

okey, it means if will ot mention third parameter in case of 5 thn it would display '5' as in case of 4 it had done..

now its clear to me.

thank u so much sir

Apply Map

Wed, 30 May 2012 09:07:05 GMT

Hi sokkorn,

I have a doubt. In ur table, u mention like ' - ' symbol. I tried this example without giving that symbol in mapping. Instead the symbol i got customerid again in the customername filed.. help me in this..

Apply Map

Wed, 30 May 2012 09:22:15 GMT

Hi Manimaran,

the '-' used in the above code is an optional keyword. If you dont use this then you will get the same value for those who does not exist in the mapping table.

Thanks & Best Regards,

Kuldeep Tak

Re: Apply Map

Thu, 12 Mar 2015 04:51:47 GMT

ApplyMap( 'mapname', expr [ , defaultexpr ] )

Maps any expression on a previously loaded mapping table. Expr is

the expression whose result shall be mapped. Mapname is the name

of a mapping table previously loaded by a mapping load or mapping

select statement . The name must be quoted

with single quotes. Defaultexpr is an optional expression, which

will be used as default mapping value if the mapping table does not

contain any matching value for expr. If no default is provided, the

value of expr is returned as is.

SCRIPT EXPRESSIONS

421

Examples:

// Assume the following mapping table

map1:

mapping load * inline [

x,y

1,one

2,two

3,three];

ApplyMap( 'map1' , MyVal ) returns 'two' if MyVal = 2

ApplyMap( 'map1' , MyVal ) returns 4 if MyVal = 4

ApplyMap( 'map1' , MyVal, 'x' )

returns 'x' if MyVal <> 1, 2 or 3

ApplyMap( 'map1' , MyVal, null() )

returns null if MyVal <> 1, 2 or 3

ApplyMap( 'map1' , MyVal, null() )

returns 'one' if MyVal = 1

Reference from Qlikview reference manual