Lookup, ApplyMap, Joins - Need Help

[Anonymous]

Table A
Ticket No	Customer Name
123	Shankar
121	Arun
31231	Vijay
34535	Sandy
3534	James

Table B
Customer	City
Shankar	Chennai
Arun	Madurai
Vijay	Singapore
Sandy	Belgium
James	USA

I want to map the city in Table B to the Customer Names in Table A.

1. I have tried renaming the Customer in Table B as Customer Name to create a sync but the result is not accurate.

Is there a way to create a lookup or applymap or any better solution? Please suggest.

[Colin-Albert]

Are your attachments still being moderated as I cannot see any attached files.

[Anonymous]

Hi Colin,

Attaching again..

[Colin-Albert]

No attachment. Can you just paste the relevant section of your load script into the post

[Anonymous]

TableA:

LOAD [Ticket No],

    [Customer Name],

    ApplyMap('TableB',[Customer Name],'Not Specified') as City

FROM

(ooxml, embedded labels, table is Sheet1);

TableB:

LOAD Customer,

    City

FROM

(ooxml, embedded labels, table is Sheet1);

[Colin-Albert · Accepted solution]

Try this, You just had the word MAPPING missing from your load of Table B, and you must load the mapping table BEFORE you use the applymap command.

TableB:

MAPPING LOAD

        Customer,

         City

FROM

(ooxml, embedded labels, table is Sheet1);

TableA:

LOAD [Ticket No],

    [Customer Name],

    ApplyMap('TableB',[Customer Name],'Not Specified') as City

FROM

(ooxml, embedded labels, table is Sheet1);

[Anonymous]

Colin - It worked.

I have no words to appreciate you friends.

Special thanks to Colin and Chandel..