Change field name in script via table

alex59800 — Wed, 15 Apr 2015 14:20:30 GMT

Hello all,

I have a little problem for several qvw script.

I would know if there is an existing too that will be able to read the all script and change field name through a table with old and new field.

I had to change all field by aliases in script, but what i need to rename is not proprely the aliases but the original field name from the databasis (DB400 from IBM). In my example strange name before aliases.

A tool which would modify everything through a table old/new field (i have a lots of fields concerned in differents tables) would be wonderful !

Example :

LOAD NMEN000LB as [Street number],

CMLX000LB as [street adress 1],

NMON000LB as [street adress 2],

CDPT000 as [zip code],

NMBL000LB as [City],

PSGL000CD as [Country],

TLAL000RF as Phone,

FXAG000CD as Fax,

CNAD000LB as email;

SQL SELECT *

FROM XXXX.XXXX.GFGADR

I tried to found some text editors, but i can not find something like that.

Thank you for your help guys !

Re: Change field name in script via table

jpenuliar — Wed, 15 Apr 2015 14:29:09 GMT

might be the one you're looking for:

How to Rename Fields

Re: Change field name in script via table

alex59800 — Wed, 15 Apr 2015 14:38:44 GMT

Hi Johnatan, are you sure you can use this to modify a full script in a .csv or word file ? (full text)

Best regards

topic Re: Change field name in script via table in QlikView

Change field name in script via table

Re: Change field name in script via table

Re: Change field name in script via table