Data transformation Question

I am working on a report where the data looks like below (sample data):

Services : JAS, GAF and YAG fall under the profit center "ABC" and HIG and OPD falls under "XYZ"

Date

Profit Center

Service

1/1/24

ABC

1/1/24

JAS

1/1/24

GAF

1/1/24

YAG

1/1/24

XYZ

1/1/24

HIG

1/1/24

OPD

I want my final output to look like below, there should be a profit center for each service in each row.

Date

Profit Center

Service

1/1/24

ABC

XCS

1/1/24

ABC

JAS

1/1/24

ABC

GAF

1/1/24

ABC

YAG

1/1/24

XYZ

HIG

1/1/24

XYZ

OPD

Can someone please guide me how can we do that in domo etl ? I know that window functions (lag,lead) aren't supported in Domo's mysql, so trying to find a solution with magic etl.

Thankyou

Best Answer

Answers