Replace filed values to the other tables field value

[Awais-Ashraf]

Hello !

i want to replace the values of a field from one table to the values of the other table. the issues i am facing is that i get "appley map error"

I have the fields name "Customer" and "NAME" i want all the values for "Name" to be replaced by "Customer".
The name of the tables are Customer and KNA. 

CustomerMAP:
Mapping LOAD
RowNo() as key,
Customer

FROM [lib://data 2/SalesDetail Demo.xlsx]
(ooxml, embedded labels, table is Customer);

KNA1:
LOAD

RowNo() as key,

NNR,
ApplyMap(NAME1, Customer) as Customer




FROM [lib://data/KNA1.qvd]
(qvd);

Thanks

[jwjackso · Accepted solution]

The first argument of ApplyMap is a string that is the map name, in your case that would be 'CustomerMAP'.   The second argument will be the field used in the map.  Is NAME1 a numeric that matches the RowNo that you as the Key?

ApplyMap('CustomerMAP',NAME1) as Customer