topic Can I Drop a Field and Rename it in QlikView

Can I Drop a Field and Rename it

Anonymous — Tue, 08 Mar 2016 18:36:18 GMT

Hi All,

I have a preceding load wherein I am creating Calculated Fields to be used in the same Load statement.

I want to Keep the field name Date. so can I drop Date after renaming Date_1 into Date?

Load*,

Rename Date_1 into Date;

Drop Field Date;

Load*,

if (Date_2 ='X', 'Flag', Date) as Date_1 ;

Saravanan_Desingh — Tue, 08 Mar 2016 18:44:27 GMT

Hi,

Push the Rename and Drop after the LOAD statement.

Load *,

if (Date_2 ='X', 'Flag', Date) as Date_1 ;

Load * From [File];

Rename Field Date_1 to Date;

Drop Field Date;

Saravanan_Desingh — Tue, 08 Mar 2016 18:46:16 GMT

Sorry.. It should be..

Drop Field Date_1;

sunny_talwar — Tue, 08 Mar 2016 18:49:30 GMT

I would suggest changing the order of Rename and Drop as well

DROP Field Date;

Rename Field Date_1 to Date;