Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Are your attachments still being moderated as I cannot see any attached files.
Hi Colin,
Attaching again..
No attachment. Can you just paste the relevant section of your load script into the post
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);
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);
Colin - It worked.
I have no words to appreciate you friends.
Special thanks to Colin and Chandel..