Creating a date column that generates dates against daily data

[Trien_Hard]

Hello all,

I am wanting to create a date column against this data which is representing daily values. In this we would have the below data generate for each date.

Hope this makes sense.

Thanks in advance 🙂

[ryan_mayu]

not clear about your request.

what's the expected output based on the sample data you provided?

What's more ,could you pls paste the data in the post or reply(not the screenshot)

[Trien_Hard]

Here is the reference table as shown in the original post.

Subregionid	FullTimeCount	Daily Hours
ENC-SG	26	148.2
ENC-TH	8	45.6
ENC.HK	6	34.2
ENC.KR	14	79.8
SC.ACT	5	28.5
SC.ADL	12	68.4
SC.FIJI	8	45.6
SC.FNQ	2	11.4
SC.HOB	1	5.7
SC.MEL	38	216.6
SC.NZ	9	51.3
SC.PTH	9	51.3
SC.SEQ	11	62.7
SC.SYD	36	205.2

The below table would be the expected result, with the "Subregionid" being transposed accross the date table and the referenced corresponding "Daily Hours" being duplicated accross all dates.

Date	Month	Month-Year	Month-Year1	Is Working Day	ENC-SG	ENC-TH	ENC.HK	ENC.KR	SC.ACT	SC.ADL	SC.FIJI	SC.FNQ	SC.HOB	SC.MEL	SC.NZ	SC.PTH	SC.SEQ	SC.SYD
1/01/2021 0:00	Jan	Jan-21	202101	1	148.2	45.6	34.2	79.8	28.5	68.4	45.6	11.4	5.7	216.6	51.3	51.3	62.7	205.2
2/01/2021 0:00	Jan	Jan-21	202101	0	148.2	45.6	34.2	79.8	28.5	68.4	45.6	11.4	5.7	216.6	51.3	51.3	62.7	205.2
3/01/2021 0:00	Jan	Jan-21	202101	0	148.2	45.6	34.2	79.8	28.5	68.4	45.6	11.4	5.7	216.6	51.3	51.3	62.7	205.2
4/01/2021 0:00	Jan	Jan-21	202101	1	148.2	45.6	34.2	79.8	28.5	68.4	45.6	11.4	5.7	216.6	51.3	51.3	62.7	205.2
5/01/2021 0:00	Jan	Jan-21	202101	1	148.2	45.6	34.2	79.8	28.5	68.4	45.6	11.4	5.7	216.6	51.3	51.3	62.7	205.2
6/01/2021 0:00	Jan	Jan-21	202101	1	148.2	45.6	34.2	79.8	28.5	68.4	45.6	11.4	5.7	216.6	51.3	51.3	62.7	205.2

[ryan_mayu · Accepted solution]

@Trien_Hard 

pls see the attachment below