topic Re: Rename field from particular table only in QlikView

Rename field from particular table only

priyarane — Tue, 04 Jul 2017 10:44:46 GMT

hi Community,

Is there any option to rename from particular table.

I have scenario like

table1:

;

table2:

;

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 — Tue, 04 Jul 2017 11:12:47 GMT

Hi ,

You can use rename function.

And while loading table1

Qualify A;

table1:

UnQualify *;

Rename field table1.A to XXX;

Regards,

Ravi Balar

Anil_Babu_Samineni — Tue, 04 Jul 2017 11:16:44 GMT

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 — Tue, 04 Jul 2017 11:29:18 GMT

You can use Resident Load

table1:

;

NewTable:

Load

A as XX,

B as YY,

C as ZZ

Resident table1;

Drop table table1 ;