Produce future months data based on last excel file in the folder

[ngreddy1982]

Hi all,

I have loaded excel files in a folder to an app, I would like to take the last file in the folder as a source and replicate the same data for future months with dates

For example: in the attached, I have an excel for Jan 2022, I would to replicate the same data for Feb, March And April and also DateKey will be 2022-02-01, 2022-03-01 and 2022-04-01 respectively. 

Thanks in advance for your time.