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 |
