topic Re: Rename in QlikView

Rename

andrea90casa — Wed, 06 Sep 2017 12:53:54 GMT

Hi at all,

I always use in the script the term "as" in order to change a field name.

But this morning I have generated this script and I don't know why I can't change data in Data (the table load all data but field data doesn't change the name),

Database:

SQL SELECT

zona,

doc,

ndoc,

data as Data,

codfocl,

rag_soc,

progetto,

cod_agente

From EXT_QLIK.dbf;

Anyone can help me to understand?

Re: Rename

its_anandrjs — Wed, 06 Sep 2017 13:00:09 GMT

Try this to load

Database:

Load

zona,

doc,

ndoc,

data as Data,

codfocl,

rag_soc,

progetto,

cod_agente;

SQL SELECT

zona,

doc,

ndoc,

data ,

codfocl,

rag_soc,

progetto,

cod_agente

From EXT_QLIK.dbf;

Re: Rename

sunny_talwar — Wed, 06 Sep 2017 13:01:51 GMT

May be try this

Database:

SQL SELECT

zona,

doc,

ndoc,

data as "Data",

codfocl,

rag_soc,

progetto,

cod_agente

From EXT_QLIK.dbf;

Re: Rename

andrea90casa — Wed, 06 Sep 2017 13:03:03 GMT

Thanks Anand

I found another solution before but yours is more elegant than mine:

Gestionale:

SQL SELECT

zona,

doc,

ndoc,

data,

codfocl,

rag_soc,

progetto,

cod_agente

From EXT_QLIK.dbf;

Ges:

LOAD

zona,

ndoc,

codfocl,

rag_soc,

cod_agente,

data as Data,

progetto as PROGETTO

Resident Gestionale;

DROP Table Gestionale;

Re: Rename

its_anandrjs — Wed, 06 Sep 2017 13:07:39 GMT

Absolutely correct this also you can try this way also please check script for that.

Gestionale:

SQL SELECT

zona,

doc,

ndoc,

data,

codfocl,

rag_soc,

progetto,

cod_agente

From EXT_QLIK.dbf;

Store Gestionale into Gestionale.qvd(qvd);

Drop Table Gestionale;

Ges:

LOAD

zona,

ndoc,

codfocl,

rag_soc,

cod_agente,

data as Data,

progetto as PROGETTO

From Gestionale.qvd;

Store Ges into Ges.qvd(qvd);

DROP Table Ges;

You can create the Qvds of this SQL load tables.

Re: Rename

andrea90casa — Wed, 06 Sep 2017 13:07:43 GMT

Hi Sunny

I tried with "Data" but it doesn't work find.

I don't know why but i thank you for your suggest

Andrea