how to set a MAgic ETL to only filter out past 12 months data

My raw data contains 2.5 years worth of data and I only wanted to have the past 12 months of data for my next step dataflow to reduce the runtime.  I wanted to do this in Magic ETL, is there a way to set up the date filter for last 12 months?  I only see to set up a date filter for a specific date.

 

Thank you.

 

OZ  

Comments

  • Atanas
    Atanas Sydney, Australia

    domo

    💎

    A 2 step approach that would work in Magic ETL:

    Screen Shot 2019-04-30 at 4.35.28 PM.png

    1. Create a "Date Operations" column that will subtract 365 days from the Current Date, call the column something clear like "Current Date minus 365 days"

    Screen Shot 2019-04-30 at 4.33.07 PM.png

     

    2. Add a filter component to filter the date field of interest on the "Current Date minus 365 days" column

    Screen Shot 2019-04-30 at 4.33.20 PM.png