Script calculation

[#1]

Hi,

I have 3 files with data in multiple currencies and 1 file with the Currency Rates.

I would like to have the script to look at the Currency field in the data table(s), find the corresponding Rate in the Currency Table and calculate the Euro rate, the have the result of that calculation show up as a column.

I'm still pretty new at this, so can anyone give me some pointers on how to do this? So far, all my attempts have failed.

Would be much appreciated.

[Clever_Anjos]

Check this: Currency Conversion

[#3]

If you have the Currency rate on each day, just add the currency rate based on your transaction date with ApplyMap.

Please post some sample data