Duplicated rows based on the number of times the request has been made.
Hello, My name is Amaury Cabrera, and I would like to request your assistance with the following: I have a table containing information about recurring requests (both monthly and quarterly, etc.) from the BI department. The table includes the Start Date of the request (when it initially began) and the Recurrence Cancelation Date. If the request has not been completed yet, the Recurrence Cancelation Date field will be empty. What I need is to create a new table or modify the existing one so that each record is duplicated based on the number of times the request has been made. In other words, if the request was made six times from the start to the end of its validity period, I need the record to be duplicated six times with a new column indicating the date on which each request was made. For example: ID REQUEST / REQUEST NAME / START DATE / CANCELATION DATE / RECURRENCE 001 / Monthly sales report entry / (01/01/23) / BLANK / MONTHLY If today's date is (06/06/23), then I would like to have the following: ID REQUEST / REQUEST NAME / START DATE / CANCELATION DATE / RECURRENCE / DATE PERFORMED 001 / Monthly sales report entry / (01/01/23) / BLANK / MONTHLY / (01/01/23) 001 / Monthly sales report entry / (01/01/23) /BLANK / MONTHLY / (02/01/23) 001 / Monthly sales report entry / (01/01/23) / BLANK / MONTHLY / (03/01/23) 001 / Monthly sales report entry / (01/01/23) / BLANK / MONTHLY / (04/01/23) 001 / Monthly sales report entry / (01/01/23) / BLANK / MONTHLY / (05/01/23) 001 / Monthly sales report entry / (01/01/23) / BLANK / MONTHLY / (06/01/23) Nota LINK EXAMPLE DATA: DATA Thank you in advance for your assistance. Best regards,