How to get data for the last 5 months from an year's data in magic ETL?

user081659

Need to get the data for 5 months from current 1st of month using magic ETL. It needs to adjust back to 5 months automatically from the current month. 

 

Help will be much appreciated.

 

Thanks.

Jarvis

It's probably possible with the Magic ETL, however, I'm more accustomed to the SQL transform.

 

If you did this SQL transform, you could limit your data to only the last 5 months.

 

SELECT * 

FROM table 

WHERE `datefield` >= DATE_SUB(DATE_FORMAT(`datefield`, '%Y-%m-01'), INTERVAL 1 MONTH)

AND `datefield` <= LAST_DAY(DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH))

 Hopefully, this might help. Or if not, maybe someone else can chime in regarding the Magic ETL.

You can also take the SQL dataset and bring in the output into a Magic ETL and go from there.