Rename

[andrea90casa]

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?

[its_anandrjs · Accepted solution]

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;

[sunny_talwar]

May be try this

Database:

SQL SELECT

zona,

doc,

ndoc,

data                    as "Data",

codfocl,

rag_soc,

progetto,

cod_agente

From EXT_QLIK.dbf;

[andrea90casa]

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;

[its_anandrjs]

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.

[andrea90casa]

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