How to filter dataset for various date ranges

[apatel1501]

I have two data sets. One is my main dataset consisting of transaction data from a company and has a date for each row (the date of the transaction. The other is a table that looks like the below.

My question: How can I (without needing to create extra fields in the transaction data) use the attached to filter the transaction dataset into 3 different datasets (one for each period) and then union them together. You can see that the last date range has an overlap with the second one, that's why i need it to filter into 3 different datasets, and then i can restack them.

Hope that was clear. Thanks.

[apatel1501]

Update - i think i could use row generator to solve this and then filter using a join.

So my question i guess is - how can i use row generator to generate rows for each day between a StartDate and EndDate field

Start Date          End Date

2022-01-01       2022-12-31
2023-01-01       2023-12-31
2022-10-01       2023-09-30

[flying008 · Accepted solution]

Hi, @apatel1501 

FYI.

[apatel1501]

Perfect - thanks!