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

Reply
Yellow Belt

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  

Visitor

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

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

Announcements
Dojo Day is Coming! Mark your calendars for May 30th 0900-1700 MST Click here for more information