🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

How to Import Data with Date Column YYYY-MM-DD (ISO 8601)

User: "thomas_wiedmann"
New Altair Community Member
Updated by Jocelyn

I try to Import some CSV Data into RapidMiner including some date column. I get ISO 8601 Date format YYYY-MM-DD.

https://en.wikipedia.org/wiki/ISO_8601

 

Now I will change imported data type from polynominal to date. I just get errors like.

 

1. Import RAW Data - polynominal

RapidMiner2.JPG

 

 

2. Change type to date looks like this "red error monster"

RapidMiner3.JPG

 

Data

EINGANG
2010-06-07
2011-03-02
2013-03-08
2015-03-02
2017-03-10
2011-01-03
2013-01-02
2015-02-02
2016-12-22
2011-08-09
2013-07-31
2015-07-27

How can I change this ISO_8601 Date standard format to rapidminer date?

 

Thanks!

Thomas

 

Find more posts tagged with

Sort by:
1 - 2 of 21
    User: "David_A"
    New Altair Community Member
    Accepted Answer

    It seems that the import wizard can only handle date that match exactly the predefined formats in the drop-down menu.

    In your case you only habe yyyy-MM-dd and not yyyy-MM-dd HH:mm:ss .

     

    In this case, just use the Nominal to Date Operator and specify yyyy-MM-dd as date format.

     

    Best,
    David

    User: "Marco_Boeck"
    New Altair Community Member
    Accepted Answer

    Hi,

     

    I cannot reproduce the problem. You can enter "yyyy-MM-dd" in the Date Format field and then it'll work. You need to press "Enter" after changing the date format field or click somewhere outside of the date format textfield for manual changes to take effect, but that's about it.

     

    Regards,

    Marco

     

    works.png