my input :
Item Price FromDate ToDate
A 10 2023-05-01 2023-06-30
A 15 2023-07-01 2023-09-03
A 14 2023-09-04 2023-11-02
A 12 2023-11-03 2024-01-31
A 17 2024-02-01 9999-12-31 (Current price as of today)
Expected output: (If i run it today)
Item Price FromDate ToDate
A 10 2023-05-01 2023-05-31
A 10 2023-06-01 2023-06-30
A 15 2023-07-01 2023-07-31
A 15 2023-08-01 2023-08-31
A 14 2023-09-01 2023-09-30
A 14 2023-10-01 2023-10-31
A 12 2023-11-01 2023-11-30
A 12 2023-12-01 2023-12-31
A 12 2024-01-01 2024-01-31
A 17 2024-02-01 2024-02-29
A 17 2024-03-01 2024-03-31
A 17 2024-04-01 2024-04-30
A 17 2024-05-01 2024-05-31
I used generate rows tool but getting duplicates, please help me
