Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Awais-Ashraf
Contributor
Contributor

Replace filed values to the other tables field value

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

Labels (1)
1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

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

View solution in original post

1 Reply
jwjackso
Specialist III
Specialist III

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