The Altair Community is migrating to a new platform to provide a better experience for you. In preparation for the migration, the Altair Community is on read-only mode from October 28 - November 6, 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

how can i only retrive only last week transaction from my data

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
in Help
Hello,
I have data customer that contains transaction ,I want to display last week/last month transaction,In data I have INPUTDATETIME of transactions.
e.g I have below data
3077.0 MEDIUM Y ABNA0000003694 Sat Feb 01 10:05:32 IST 2020
3077.0 MEDIUM Y ABNA0000003694 Sun Aug 02 10:05:32 IST 2020
3077.0 MEDIUM Y ABNA0000004694 Fri Aug 07 10:05:32 IST 2020
3077.0 MEDIUM Y ABNA0000004694 Sat Aug 08 10:05:32 IST 2020
3077.0 MEDIUM Y ABNA0000005694 Sun Aug 09 10:05:32 IST 2020
3077.0 MEDIUM Y BNA000060056945 Tue Aug 04 10:05:32 IST 2020

Answers

  • MartinLiebigMartinLiebig Administrator, Moderator, Employee-RapidMiner, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,533 RM Data Scientist
    Hi,
    you can use Filter Examples with expression. Something like
    date > date_add(date_now(),-7,DATE_UNIT_DAY)
    should do it.
    Best,
    Martin
    - Sr. Director Data Solutions, Altair RapidMiner -
    Dortmund, Germany
Sign In or Register to comment.