ApplyMap(), looking for advice?

[#1]

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

[kaushiknsolanki]

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 · Accepted solution]

Hi Michael,

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

Regards,

Sokkorn

[#4]

it works. Thanks.

[#5]

Thanks. it is work.