Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

priyarane
Contributor III

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
Contributor III

Re: Rename field from particular table only

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

Re: Rename field from particular table only

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
Honored Contributor III

Re: Rename field from particular table only

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 ;