- Last Active
I referred the manual writeup . You are doing Last Quarter Calculation select d.`dt` as "Report Date", date_sub(`dt`, interval '1' quarter) as "Comparison Date", 'Last Quarter' as 'Period Type' from `calendar_dates` d How would you do Current Quarter to date and Previous Year Quarter to Date?
How would you do the same in magic ETL. For instance if I need to coalesce one column to another only when value is in a pattern