I am a total newbie in Pentaho Kettle/Spoon. I am reading a transaction table with amounts in different transaction currencies. The requirement is to convert the amounts in standardized currencies(in this case, EUR and USD) using the live exchange rates. What should be my approach? What are the steps of the transformation need to be considered?
Any input is appreciated.
As far as I understood you have a table with many different currencies and want to convert those to usd and eur right? I think you will need a webservice or a table that delivers the current conversion rates for this