Options

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

sgnarkhede2016sgnarkhede2016 Member Posts: 152 Contributor II
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

  • Options
    MartinLiebigMartinLiebig Administrator, Moderator, Employee, RapidMiner Certified Analyst, RapidMiner Certified Expert, University Professor Posts: 3,517 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.