| CATEGORY | DATE(DD.MM.YYYY) |
|---|---|
| a | 01.01.2024 |
| a | 02.01.2024 |
| a | 03.01.2024 |
| a | 04.01.2024 |
| a | 05.01.2024 |
| b | 01.01.2024 |
| b | 10.01.2024 |
| b | 15.01.2024 |
| c | 01.01.2024 |
| c | 11.01.2024 |
| c | 25.01.2024 |
I am trying to get the below in a single query:
| CATEGORY | DATE(DD.MM.YYYY) |
|---|---|
| a | 01.01.2024 |
| a | 02.01.2024 |
| a | 03.01.2024 |
| a | 04.01.2024 |
| a | 05.01.2024 |
| b | 10.01.2024 |
| b | 15.01.2024 |
| c | 25.01.2024 |
Rougly something like if CATEGORY = a then DATE >= 01.01.2024
CATEGORY = b then DATE >=10.01.2024
CATEGORY = c then DATE >=25.01.2024
.
.
.
I am working with a data sets over 300k+ rows and over 10k+ distinct CATEGORY variables and I have a seperate excel file that contains CATEGORY variables and the DATE variables corresponding to the CATEGORY variables. Something like below:
| CATEGORY | DATE |
|---|---|
| a | 01.01.2024 |
| b | 10.01.2024 |
| c | 25.01.2024 |
Is it possible to do so? Thank you for your contribution and time.