Renaming Fields using 'Rename Field'

[#1]

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.

[Anonymous]

By using the as to rename the field name

[PradeepReddy]

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;

[Anonymous · Accepted solution]

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;