Monthly to daily

[apaicanada]

I would like to convert my monthly values to daily values (i.e. just duplicating the values I have for each item for each day of the month).

I currently have this:

Record	Commodity	Value	Date
1	Oil	800	2010-01-01
2	Natural Gas	700	2010-01-01
3	Diesel	600	2010-01-01
4	Oil	900	2010-02-01
5	Natural Gas	650	2010-02-01
6	Diesel	200	2010-02-01

But would like it to be like: 

Record	Commodity	Value	Date
1	Oil	800	2010-01-01
2	Oil	800	2010-01-02
3	Oil	800	2010-01-03
4	Oil	800	2010-01-04
5	Oil	800	2010-01-05
6	Oil	800	2010-01-06
etc	etc	etc	etc

And so on for each commodity for year and each month till the end of my dataset (which goes till 2021, but I would like it to be dynamic). 

I have tried some formulas and row generations but am not getting too far. Any help is appreciated!

Thanks so much,

Akarsh

[Thableaus · Accepted solution]

Hi @apaicanada 

This should work

Date2 is your daily date Field.

WF attached.

Cheers,

[DiganP · Accepted solution]

@apaicanada You can use the generate rows tool to create the rows.

 

Attached is the workflow.

[LordNeilLord]

Hey @apaicanada 

Generate rows is your friend here: