Changing Data in Rapidminer
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