Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Rename field from particular table only

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

3 Replies
balar025
Creator III
Creator III

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

.......

.....

];

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
prma7799
Master III
Master III

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 ;