Help : load all the files and insert calculated columns

[Anonymous]

Hi

I want to load all the colums of a qvd file :

LOAD * FROM

\\As01\qlikview\loader\QV_TOU_FACTURATION.QVD

(qvd);

but I also want to add some other calculated columns like

year( DATE_ARRIVEE_PRODUIT) as YEAR_ARRIVEE_PRODUIT,

What is the syntax I have to use in the expression loader.

It works if I write all the colums that exist in the qvd file:

LOAD

     CS_PID,

     DATE_ARRIVEE_PRODUIT,

     year( DATE_ARRIVEE_PRODUIT) as YEAR_ARRIVEE_PRODUIT,

     ....

     ....

     ...

     ....

FROM

\\As01\qlikview\loader\QV_TOU_FACTURATION.QVD

(qvd);

But I have enormously colums and I would prefer to charge all the colums in one expression by using " * "

Thanks for your help

Laurent

[kaushiknsolanki]

Hi,

     You can try like this.

     Load *,Year(Date) as year.

Regards,

Kaushik Solanki

[Anonymous]

Hi

I have the message

Erreur de syntaxe, FROM manquant ou mal placé :

LOAD *,

I have attached my document, if necessary

Thank

[kaushiknsolanki · Accepted solution]

Hi,

     You must remove the ',' Comma from the last field name.

     Have a look at the attachment.

Regards,

Kaushik Solanki

[Anonymous]

Thanks a lot

[Anonymous]

Hi

Thank you for your response

What is the syntax if in place of a qvd file, I have an sql table

Select SQL *,

....

from....

It doesn't work

[kaushiknsolanki]

Hi Try this

     Load *,year(Date) as Year;

     Sql Select * from abc;

     Just include the load statement as shown above.

Regards,

Kaushik Solanki

[Anonymous]

Hi

I think you have not understand what I mean

If I have just an sql select inplace of a LOAD from a qvd file, the syntax

SQL SELECT *,

     year(DATE_ARRIVEE_PRODUIT) as YEAR_ARRIVEE_PRODUIT

FROM `QV_DB`.`QV_TOU_FACTURATION`;

doesn't work

What is the right syntax ?

Reagrds

[kaushiknsolanki]

Hi,

     I am sorry i couldnt able to explain properly.

     See the code i have given in earlier post is right.

     That script doesnt take data from Qvd;

     Let me show you the script and explain its working.

     Load *,year(Date) as Year; 

     Sql Select * from abc;

     Here QlikView will take the data from Database and then it will do the calculations to create calculated columns and then give output with both calculated columns and all other original columns.

     As you see in script after load statement there is no from column, only ; is there.

     Hope this is clear. Try the code and let me know.

Regards,

Kaushik Solanki

[Anonymous]

Great It Works

Thanks