Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Michael,
User this ApplyMap('Mapping table A', CustID, 'Unknown') as [Full Name],
Regards,
Sokkorn
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
Hi Michael,
User this ApplyMap('Mapping table A', CustID, 'Unknown') as [Full Name],
Regards,
Sokkorn
it works. Thanks.
Thanks. it is work.