"Changing .csv data."

redbaron1981redbaron1981 Member Posts: 3 Contributor I
edited May 2019 in Help
Hey Guys,

Can anyone help me with this query or point me in the right direction?

I am new to Rapid but I've been trying to edit this data from a forex database. It is in .CSV so I import it into Rapid but I'd like to change the date and time columns so they are a little more usable. This is how it appears after import:


But I'd like to have it like this:


My plan is once I have the date and time in a more useable format I then want to run queries through the data and export the results to R or Matlab!

Any help would be much appreciated.



  • Options
    landland RapidMiner Certified Analyst, RapidMiner Certified Expert, Member Posts: 2,531 Unicorn
    please take a look at the Nominal to Date operator. You can enter there arbitrary Date Formats to extract the real (numerical) date. You can then filter on this accordingly.

Sign In or Register to comment.