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.
