Calculated value in the main script

[#1]

Hi Experts,

I'm wonder if it's possible to creat a calculate field in the main script.

My datasource are an excel file.

Example :

LOAD Date,

     Libellé,

     Débit,

     Crédit    

FROM

C:\Users...

I aim to do something like this:

LOAD Date,

     Libellé,

     Débit,

     Crédit,

     Sum(Credit+Debit) as Total

FROM

C:\Users...

Is it possible ?

Regards,

Pierre.

[nagaiank · Accepted solution]

Yes. Try the following:

LOAD *, Crédit + Débit as Tot;

LOAD Date,

     Libellé,

     Débit,

     Crédit   

FROM

C:\Users...

[#3]

It works, thanks.