Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Attempting to use ApplyMap to search for matching Data from the first table called 'InventoryList' and the field name containing the Data is called 'PMDescription'. The second table contains multiple fields that has the same I would like to join and I keep getting MAPPING requires 2-column input. What is the propoer syntax. Works fin when I try to map a single field.
Example:
Directory;
SapSearchTable:
Mapping LOAD
PMDescription,
AssetBarCode,
Username
FROM
[Fixed Asset Register Recon Jan WIP For Thabo Data-Man.xlsm]
(ooxml, embedded labels, table is InventoryList);
Directory;
FoundTable:
LOAD PartNumber,
ApplyMap('SapSearchTable',PartNumber,0) as PartNumber1,
[SAP Asset Number],
Subnumber,
ApplyMap('SapSearchTable',Subnumber,'NA') as Subnumber2,
[Capitalized on],
ApplyMap('SapSearchTable', [Capitalized on],'NA') as [Capitalized on1],
Description,
ApplyMap('SapSearchTable', Description,'NA') as Description2,
Inventorynumber,
ApplyMap('SapSearchTable', Inventorynumber,'NA') as Inventorynumber2,
PartNumber1,
ApplyMap('SapSearchTable', PartNumber1,'NA') as PartNumber2,
SerialNumber,
ApplyMap('SapSearchTable', SerialNumber,'NA') as SerialNumber2,
[asset class no],
ApplyMap('SapSearchTable', [asset class no],'NA') as [asset class no1],
[asset class]
FROM
[Fixed Asset Register Recon Jan WIP For Thabo Data-Man.xlsm]
(ooxml, embedded labels, table is [Fixed Asset Register 1PART]);
store Found into C:\Users\BET\Downloads\10k;
A mapping table is only a temporary table that exists only whilst the load script is being run. The purpose of a mapping table is to "map" field values from one source onto another. In your case for example the value of AssetBarCode from your mapping table is now contained in your primary table, and is contained within specific fields according to the value of PMDescription.
So the question is, why would you also want the source table itself?
It shouldn't be of any value to you.