Hi,
I am new to Alteryx. I have two files, a main file and a reference file with various dates. My intention is if the dates in Date_main column are between the range of Start Date and End Date then it show the appropriate fruit name next to the Date_Main column. Not sure how to structure the workflow.
Thanks.
Main file
Date_Main |
10/9/2022 |
8/3/2022 |
8/10/2022 |
12/21/2019 |
2/7/2021 |
11/13/2019 |
7/28/2020 |
9/20/2019 |
6/23/2020 |
4/22/2021 |
1/28/2020 |
4/30/2021 |
11/8/2022 |
7/21/2020 |
10/18/2020 |
2/3/2020 |
9/5/2019 |
7/13/2021 |
3/1/2022 |
4/8/2021 |
12/21/2019 |
2/7/2021 |
11/13/2019 |
10/7/2020 |
Reference file
Fruit | Start Date | End Date |
Apple | 7/1/2019 | 9/2/2019 |
Watermelon | 9/3/2019 | 10/27/2019 |
Orange | 10/28/2019 | 1/12/2020 |
Pear | 1/13/2020 | 3/8/2020 |
Cherry | 3/9/2020 | 5/3/2020 |
Strawberry | 5/4/2020 | 6/28/2020 |
Nectarine | 6/29/2020 | 8/30/2020 |
Grape | 8/31/2020 | 10/25/2020 |
Mango | 10/26/2020 | 1/10/2021 |
Blueberry | 1/11/2021 | 3/7/2021 |
Pomegranate | 3/8/2021 | 5/2/2021 |
Starfruit | 5/3/2021 | 6/27/2021 |
Plum | 6/28/2021 | 8/29/2021 |
Banana | 8/30/2021 | 10/24/2021 |
Raspberry | 10/25/2021 | 1/9/2022 |
Mandarin | 1/10/2022 | 3/6/2022 |
Jackfruit | 3/7/2022 | 5/1/2022 |
Papaya | 5/2/2022 | 6/23/2022 |
Kiwi | 6/24/2022 | 8/28/2022 |
Pineapple | 8/29/2022 | 10/23/2022 |
Lime | 10/24/2022 | 1/8/2023 |
Intended Output file
Date_Main | Fruit |
10/9/2022 | Banana |
8/3/2022 | Kiwi |
8/10/2022 | Kiwi |
12/21/2019 | Orange |
2/7/2021 | Blueberry |
11/13/2019 | Orange |
7/28/2020 | Nectarine |
9/20/2019 | Watermelon |
Hi @bryanmac_92 one way to approach this is you use a generate row tool to generate a date between your start and end date and then join it on your main file after some datetime conversations to standardise your dates.