How do i fill in the date gaps?

Tina_Alpaca · 2023-02-24T17:56:27+00:00

There was an error rendering this rich post.

Tina_Alpaca

I have a start date and an end date. How do i have those dates in between appear? (ETLs/Codes)

Find more posts tagged with

Magic ETL

Accepted answers

All comments

GrantSmith

You can utilize Magic ETL and the Domo Dimensions connector.

Using the Domo Dimensions connector pull in the calendar dataset.

Feed that into a magic ETL, add a constant call 'Join Column' for a value of 1.

Then use your dataset as an input, add a constant 'Join Column' with a value of 1 to this dataset as well in the ETL.

Then do a join between both add constant tiles based on the join column. Feed that into a filter tile and filter with a formula where the dt column from the Calendar dataset is between your start and end dates.

`dt` BETWEEN `Start Date` AND `End Date`

This will then expand your data so that you have your record for each day between your time range.

MarkSnodgrass

@Tina_Alpaca I created a video on how to do this in Magic ETL. You can watch it here:

https://www.youtube.com/watch?v=9iNpzSL5V6U

Hope this helps.