Rename field from particular table only

[priyarane]

hi Community,

Is there any option to rename from particular table.

I have scenario like

table1:

A,

B,

C

;

table2:

A,

X,

Z

;

now I have to rename field in Table1 like A as xx from table1.

while loading we can do it in table itself but I have to do it after loading only.

-Priya

[balar025]

Hi ,

You can use rename function.

And while loading table1

Qualify A;

table1:

A,

B,

C

UnQualify *;

Rename field table1.A to XXX;

Regards,

Ravi Balar

[Anil_Babu_Samineni]

I assume A,B,C are the field names. Why not simple alias name

Load A as xx, B, C Inline [

A , B, C

.......

.....

];

[prma7799]

You can use Resident Load

table1:

A,

B,

C

;

NewTable:

Load

A as XX,

B as YY,

C as ZZ

Resident table1;

Drop table table1 ;