The Altair Community is migrating to a new platform to provide a better experience for you. The RapidMiner Community will merge with the Altair Community at the same time. In preparation for the migration, both communities are on read-only mode from July 15th - July 24th, 2024. Technical support via cases will continue to work as is. For any urgent requests from Students/Faculty members, please submit the form linked here.
Options

Filtering on a data set by date

davidbdavidb Member Posts: 4 Contributor I
edited October 2019 in Help
in sql depending on type there are various ways to filter by date on days. Is there a way to easily do this in rapidminer operators? For example if I only wanted to capture data that goes back 180 days from today (date now)?

Best Answer

  • Options
    davidbdavidb Member Posts: 4 Contributor I
    Solution Accepted
    Thanks, I this is what I ended up doing. 
    seemed easier to manage the dates after converting them to epoch

    generate attributes:
    date_millis(date_now())-15552000000

    generate second attribute converting date to epoch again:

    date_millis(TEST_DATE)

    Then filter based on expression

    test_date_epoch>=date180_epoch


Answers

  • Options
    kaymankayman Member Posts: 662 Unicorn
    You could generate a new attribute containing the time difference between your date field and now, there are quite some date options available in the operator. Then you filter using this new attribute and remove it again. Not the most elegant way but it does the trick
Sign In or Register to comment.