Getting dates in one row

ozarkram

Hi All,

I am working on the data visualizer and have the data as below

The columns order,model, ord date, rec date,cur prm come from the DOMO workbench while the columns prm date -7D, prm date -14 D, prm date -28 D come from the beast mode...

I am trying to get the above data in the format below...Can you please help here..

Attached the data

Sample data.xlsx

kdeike

There are two separate pieces needed to pull this off in Magic ETL.

1. Group By Order, Model, Ord Date - get MAX of cur prm and each of the prm date fields
2. 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.

ozarkram

@kdeike ..Thank you so much!...Really appreciate your help!