topic rename fields name in QlikView

rename fields name

Thu, 10 Dec 2009 00:00:48 GMT

hi everyone,

can i rename fields name using map table ?

i need to rename all fields in one table using another table - for example:

table1:

load * inline [

@1,@2,@3

1,2,3

]

table2:

load * inline [

old_name,new_name

@1, name

@2,phone

@3,age

how can i rename the first table fields name with the two field in table2 ?

thanks....

rename fields name

Anonymous — Thu, 10 Dec 2009 08:45:24 GMT

You can use the RENAME statement:
RENAME FIELD @1 TO name;

rename fields name

rwunderlich — Thu, 10 Dec 2009 11:19:40 GMT


ROI wrote:
can i rename fields name using map table ?

Yes.

RENAME FIELDS USING mapname;

See the Ref Guide or Help.

-Rob

rename fields name

Thu, 10 Dec 2009 12:33:11 GMT

thanks... i found it in the Ref Guide

rename fields name

krishnaroopa — Fri, 09 Dec 2011 10:15:33 GMT

I used rename field to rename a field that is used in table object. After renaming, the table object still refers to oldname and mark the field as unavailable. The new field name is available in the field list?

Renaming is done dynamically during loading. I will not know the name prior.

please help out

regards

KRS