topic Re: Renaming Fields using 'Rename Field' in QlikView

Renaming Fields using 'Rename Field'

Tue, 16 Feb 2016 10:11:52 GMT

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.

Re: Renaming Fields using 'Rename Field'

Anonymous — Tue, 16 Feb 2016 10:41:29 GMT

By using the as to rename the field name

Re: Renaming Fields using 'Rename Field'

PradeepReddy — Tue, 16 Feb 2016 10:59:19 GMT

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;

Re: Renaming Fields using 'Rename Field'

Anonymous — Tue, 16 Feb 2016 11:07:04 GMT

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) ;

RENAME FIELD '$(vFieldOld)' to '$(vFieldNew)' ;

Next f;