topic Re: ApplyMap(), looking for advice? in QlikView

ApplyMap(), looking for advice?

Thu, 04 Jul 2013 07:02:33 GMT

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:

CustID	Values
A1	100
B2	200
C3	101

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

CustID	Full Name	Values
A1		100
B2		200
C3		101

Pls advice. Thanks

Re: ApplyMap(), looking for advice?

kaushiknsolanki — Thu, 04 Jul 2013 07:05:34 GMT

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

Re: ApplyMap(), looking for advice?

Sokkorn — Thu, 04 Jul 2013 07:07:28 GMT

Hi Michael,

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

Regards,

Sokkorn

Re: ApplyMap(), looking for advice?

Thu, 04 Jul 2013 07:10:25 GMT

it works. Thanks.

Re: ApplyMap(), looking for advice?

Thu, 04 Jul 2013 07:11:16 GMT

Thanks. it is work.