How do i rename these cells in table below

[#1]

Hello,

I have a table and I want Zenith and Zain in the table below load as ZN. how do I load this table. note that the table is incremental new data and new name are coming.

load * inline[

A, B, C

1, Zenith, 23

2, ECO, 40

3. UBA, 56

4.OCHE, 29

5. YYY, 67

6.RRR, 21

7.Zain, 56

]

[#2]

Load

Vendor,

ID,

Text 

FROM
($datapath)Vendor.QVD]
(qvd);

And the cells am trying to rename are in the Vendor field

[puttemans]

Then please try this :

Map_ZN

MAPPING Load * inline [

Name, Newname

Zenith, ZN

Zain, ZN ];

Load

Applymap ('Map_ZN', Vendor) as Vendor,

ID,

Text 

FROM
($datapath)Financial_Statement.QVD]
(qvd);

[#4]

let me try

[#5]

Oops didn't work

[awhitfield]

Map_ZN:

MAPPING Load * inline [

Name, Newname

Zenith, ZN
Zain, ZN ];


DATA:
load * inline [

A, B, C
1, Zenith, 23
2, ECO, 40
3, UBA, 56
4,OCHE, 29
5, YYY, 67
6,RRR, 21
7,Zain, 56

];

NoConcatenate
DATA2:
Load
A,
Applymap('Map_ZN', B) as B,
C

Resident DATA;

Drop table DATA;

[#7]

Please am confuse here find attached. excel file

[#8]

Please find attached am confused I tried it didn't work

[#9]

Find qvw file, not working

[puttemans · Accepted solution]

Good morning,

Please find attached the working file. You had 2 issues in your script; a datapath that was undefined at the start, and the correct variable not being used in the applymap function.

Kind regards,

Johan