Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have used the below script to rename fields.
ACQR_DIM:
load * inline
[data:hemanth,data:sumanth
1,2
3,4];
For f = 1 to NoOfFields('ACQR_DIM')
let vFieldOld = FieldName($(f),'ACQR_DIM');
let vFieldNew = Replace('$(vFieldOld)','data:','');
RENAME FIELD $(vFieldOld) to $(vFieldNew);
Next f;
I am getting an error like 'Syntax line error'. Could someone find our the error for me?
Enclosed is the QVW file for your information.
In your RENAME statement put your dollar expansions in single quotes.
ACQR_DIM:
load * inline
[data:hemanth,data:sumanth
1,2
3,4];
For f = 1 to NoOfFields('ACQR_DIM')
let vFieldOld = FieldName($(f),'ACQR_DIM');
let vFieldNew = Replace('$(vFieldOld)','data:','');
TRACE $(vFieldOld) ;
TRACE $(vFieldOld) ;
RENAME FIELD '$(vFieldOld)' to '$(vFieldNew)' ;
Next f;
By using the as to rename the field name
try something like this..
ACQR_DIM:
load * inline
[data:hemanth,data:sumanth
1,2
3,4];
FieldNamesMap:
MAPPING LOAD * inline
[
OldName,NewName
data:hemanth,hemanth
data:sumanth,sumanth
];
RENAME FIELDS USING FieldNamesMap;
In your RENAME statement put your dollar expansions in single quotes.
ACQR_DIM:
load * inline
[data:hemanth,data:sumanth
1,2
3,4];
For f = 1 to NoOfFields('ACQR_DIM')
let vFieldOld = FieldName($(f),'ACQR_DIM');
let vFieldNew = Replace('$(vFieldOld)','data:','');
TRACE $(vFieldOld) ;
TRACE $(vFieldOld) ;
RENAME FIELD '$(vFieldOld)' to '$(vFieldNew)' ;
Next f;