Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Rename field using Mapping

I have to remap the name of the fields.
I failed to apply the mapping function to rename the fields in CE1ARGS.qvd.
Can help me?

Mappature:
mapping load * INLINE [
Original, NewName
PALEDGER, PALEDGERNEW

];


Table_tmp:
replace load distinct
PALEDGER,
capitalize(MapSubstring('Mappature',Original)) as NewName
from CE1ARGS.qvd (qvd);

1 Reply
Not applicable
Author

I need rinomirare fields. help shows this feature but I can not write properly. Can you help? you give an example please?

FieldMap:
Mapping select oldnames, newnames from datadictionary.;
Rename fields using FieldMap;