Getting dates in one row

ozarkram · June 2022

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 · June 2022

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.

ozarkram · June 2022

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

Getting dates in one row

Answers

Categories