Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
]
Load
Vendor,
ID,
Text
FROM
($datapath)Vendor.QVD]
(qvd);
And the cells am trying to rename are in the Vendor field
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);
let me try
Oops didn't work
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;
Please am confuse here find attached. excel file
Please find attached am confused I tried it didn't work
Find qvw file, not working
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