Comments
-
There are two separate pieces needed to pull this off in Magic ETL. Group By Order, Model, Ord Date - get MAX of cur prm and each of the prm date fields Pivot the rec dates (New Magic ETL Tiles: Pivot – Domo) Left join the Pivot to Group By on Order, Model, Ord Date - drop the extra columns of the same name from Pivot.
