Conditional Append From two Inputs and No Matching Column Names

[bryanmac_92]

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

[Felipe_Ribeir0]

Hi @bryanmac_92 

One way of doing this

[JosephSerpis]

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.