Getting dates in one row

ozarkram · 2022-06-14T15:29:21+00:00

There was an error rendering this rich post.

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

Find more posts tagged with

Accepted answers

All comments

kdeike

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

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

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of