adding data daily based on one date

[EISSA]

Dear All,

I have the below table 

FACT:
LOAD
[Effective Date From],[Customer SK],[Risk] from Fact.qvd(qvd)

this table contain customer key and the risk rate for this customer from a certain date let's say  01/11/2021

in my Data Model I need this table to be by day and to have the same row duplicated from the effective date from (01/11/2021) till today 08/11/2021 so in this case I will have 9 rows and will help me better in the way I am building my schema.

Thanks.

[Or · Accepted solution]

Have a look at past questions of the same nature (perhaps replacing the to_date with today()):

https://community.qlik.com/t5/QlikView-App-Dev/Create-one-record-for-each-date-between-two-dates/td-...

https://community.qlik.com/t5/QlikView-App-Dev/Autogenerate-rows-from-start-date-to-end-date/m-p/128...