https://community.qlik.com/t5/App-Development/adding-data-daily-based-on-one-date/m-p/1856727#M70711 <P>Have a look at past questions of the same nature (perhaps replacing the to_date with today()):</P> <P><A href="https://community.qlik.com/t5/QlikView-App-Dev/Create-one-record-for-each-date-between-two-dates/td-p/968508" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/Create-one-record-for-each-date-between-two-dates/td-p/968508</A></P> <P><A href="https://community.qlik.com/t5/QlikView-App-Dev/Autogenerate-rows-from-start-date-to-end-date/m-p/1287502" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/Autogenerate-rows-from-start-date-to-end-date/m-p/1287502</A></P> <P>&nbsp;</P> Mon, 08 Nov 2021 15:58:34 GMT Or 2021-11-08T15:58:34Z https://community.qlik.com/t5/App-Development/adding-data-daily-based-on-one-date/m-p/1856706#M70707 <P>Dear All,</P> <P>&nbsp;</P> <P>I have the below table&nbsp;</P> <P>FACT:<BR />LOAD<BR />[Effective Date From],[Customer SK],[Risk] from Fact.qvd(qvd)</P> <P>this table contain customer key and the risk rate for this customer from a certain date let's say&nbsp; 01/11/2021</P> <P>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.</P> <P>Thanks.</P> <P>&nbsp;</P> Tue, 30 Nov 2021 16:25:32 GMT https://community.qlik.com/t5/App-Development/adding-data-daily-based-on-one-date/m-p/1856706#M70707 EISSA 2021-11-30T16:25:32Z https://community.qlik.com/t5/App-Development/adding-data-daily-based-on-one-date/m-p/1856727#M70711 <P>Have a look at past questions of the same nature (perhaps replacing the to_date with today()):</P> <P><A href="https://community.qlik.com/t5/QlikView-App-Dev/Create-one-record-for-each-date-between-two-dates/td-p/968508" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/Create-one-record-for-each-date-between-two-dates/td-p/968508</A></P> <P><A href="https://community.qlik.com/t5/QlikView-App-Dev/Autogenerate-rows-from-start-date-to-end-date/m-p/1287502" target="_blank">https://community.qlik.com/t5/QlikView-App-Dev/Autogenerate-rows-from-start-date-to-end-date/m-p/1287502</A></P> <P>&nbsp;</P> Mon, 08 Nov 2021 15:58:34 GMT https://community.qlik.com/t5/App-Development/adding-data-daily-based-on-one-date/m-p/1856727#M70711 Or 2021-11-08T15:58:34Z