topic Apply Map in QlikView

Apply Map

Tue, 01 Jul 2014 18:06:31 GMT

Hello

I am trying to do an apply map please tell me how do I use apply map correctly.

Table1:

Load

ID,

Field2,

Field3

;

Table2:

Load

Name,

Field4,

Field5

;

I am trying to do an applymap to map the ID in Table1 to the Name in Table2.

Please suggest applymap code for the above scenario.

Thanks

Re: Apply Map

Anonymous — Tue, 01 Jul 2014 18:14:11 GMT

so are you trying to map individual id to a name? applymap needs a mapping load of a table with two fields, first one of which should have the same values as your field in a table so QV knows what field to map with what field and based on which value.

Re: Apply Map

Tue, 01 Jul 2014 18:31:57 GMT

Hello Saradhi

Here let me explain again

Now I have modified it as you told me. Please tell me how to do the applymap now.

Hello

I am trying to do an apply map please tell me how do I use apply map correctly.

Table1:

Load

ID,

Field2,

Field3

;

TableMap:

Mapping Load

Name,

New ID

;

Table2:

Load

Name,

New ID,

Field5

;

Re: Apply Map

Anonymous — Tue, 01 Jul 2014 18:58:46 GMT

so in table 2:

load
Name,

Applymap('TableMap',Name, 'No ID or 0000') as New ID,

Field 5,

. ..

from ....

;

the third parameter is Applymap function is optional and is for instances where there is no corresponding Name value in TableMap. hope this helps.

Re: Apply Map

Anonymous — Tue, 01 Jul 2014 19:01:06 GMT

i also noticed that you posted the same issue twice...may have been an unintended mistake...but please consolidate and do not repost.

Re: Apply Map

Tue, 01 Jul 2014 19:19:24 GMT

Hello Saradhi

Here is my code for Table 1, mapping table and table2

Let me know if its correct

Table1:

Load

;

sql select * from T1;

SOBMap:

Load

NAME as ,

SET_OF_BOOKS_ID as ,

;

SQL SELECT *

FROM T2;

SOB:

Load

CHART_OF_ACCOUNTS_ID as ,

CURRENCY_CODE as ,

SHORT_NAME as ,

APPLYMAP('SOBMap',[SOB Name],[SOB ID]) as

;

SQL SELECT *

FROM T2;

Store SOB into SOB.qvd(qvd);