Changing Data in Rapidminer

Hello everyone,

I am currently working with rapidminer and I got a question for which i didnt find any helpful information yet.

For preparing my data I have a huge Excel file which i uploaded in Rapidminer. Since I want to analyse the data I need some new rows which I would like to create in Rapidminer. For example I have two rows with "Start date" and "End date" in these files and I would like to create a row in rapidminer which is

Duration = "Start date" - "End date"

or also for example I have data with the price and the currency which is different each line so I would need a join 2 tables where one is data with the currency and the other with the exchange rate so that i can create

worth in USD = amount * exchange rate

Could you help me with that?

Thanks so much