Add a calculated field from the script

[#1]

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

[Gysbert_Wassenaar · Accepted solution]

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;