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

WizardOz

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  

Atanas

A 2 step approach that would work in Magic ETL:

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"

 

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