Add a calculated field from the script

Thu, 03 Jan 2013 17:33:18 GMT

Hi ,

In the image attached I have a table loaded in line called 'Tasas' where the field 'Tasa' is a currency USD rate per month.

The table called 'APUNTES' has a field called 'SALDO' have amounts in local currency. This table is not loaded in line.

I 'm just looking for the way to add to the table 'APUNTES' a field called 'USD' which would be USD = SALDO/Tasa.

When I wrote SALDO/Tasa AS USD, the script did not recognize 'Tasa' howevere it was previously loaded.

An idea please.

Thanks

Re: Add a calculated field from the script

Gysbert_Wassenaar — Thu, 03 Jan 2013 17:46:47 GMT

You can use a mapping table and applymap:

TasasMap:

mapping load * resident Tasas;

APUNTES:

Load *, applymap('TasasMap',DIV_MES_AÑO) * SALDO as USD

from ...etc;