Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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