Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

ApplyMap(), looking for advice?

Hi All

Could anyone give me some hints related to below issue:

[Mapping table A]:

mapping LOAD * INLINE [

    ID, Name

    A1, Apple

    B2, Boy

    C3, Cat

];

[Table1]:

LOAD CustID,

ApplyMap('[Mapping table A]', CustID, 'Unknown') as [Full Name],

     Values

FROM

MappingExercise.xls

(biff, embedded labels, table is [Sheet1$]);

My excel table structure is:

CustIDValues
A1100
B2200
C3101

i would like to display full name, however, after reload the scripts, i got the result as below:

CustIDFull NameValues
A1 100
B2 200
C3 101

Pls advice. Thanks

1 Solution

Accepted Solutions
Sokkorn
Honored Contributor

Re: ApplyMap(), looking for advice?

Hi Michael,

User this ApplyMap('Mapping table A', CustID, 'Unknown') as [Full Name],

Regards,

Sokkorn

4 Replies

Re: ApplyMap(), looking for advice?

Hi,

     Try this.

Mapping_table:

mapping LOAD * INLINE [

    ID, Name

    A1, Apple

    B2, Boy

    C3, Cat

];

[Table1]:

LOAD CustID,

ApplyMap('Mapping_table', CustID, 'Unknown') as [Full Name],

     Values

FROM

MappingExercise.xls

(biff, embedded labels, table is [Sheet1$]);

Regards,

Kaushik Solanki

Sokkorn
Honored Contributor

Re: ApplyMap(), looking for advice?

Hi Michael,

User this ApplyMap('Mapping table A', CustID, 'Unknown') as [Full Name],

Regards,

Sokkorn

Not applicable

Re: ApplyMap(), looking for advice?

it works. Thanks.

Not applicable

Re: ApplyMap(), looking for advice?

Thanks. it is work.

Community Browser