rename fields name

[#1]

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....

[Anonymous]

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

[rwunderlich · Accepted solution]

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

Yes.

RENAME FIELDS USING mapname;

See the Ref Guide or Help.

-Rob

[#4]

thanks... i found it in the Ref Guide

[krishnaroopa]

Hi

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