Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Matching the date in between both dates

SH_94
11 - Bolide

Dear community, 

 

I would like to ask how can we perform the following step:

1. Checking if the date in Data B if it is in between any both date of Data A

2. If it is between any both of the dates, please show the result as per Output A

3. If the date in Data B is not between of any date in Data A, please show in Output B

SH_94_0-1647938537634.png

 

In real data , it have a lot of date and we need to check if it is between both date in Data A.

 

May i know how can we do it in this case?

 

 

Thank you.

 

4 REPLIES 4
Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @SH_94,

 

If we generate the rows required we can join on the OJD and date fields:

 

Output A:

JonathanSherman_0-1647942060689.png

 

Output B:

JonathanSherman_1-1647942125096.png

 

The results from the inner join will get your output A (that match) and the right will give you your output B (that don't match)

 

I've attached my workflow for you to download if needed!

 

Kind regards,

Jonathan

SH_94
11 - Bolide

Dear @Jonathan-Sherman ,

 

Many thanks for the prompt response.

 

May i know how to change the formula from less than to less than or equal to Closing date?

 

thank you.

Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @SH_94,

 

You'll want to change the Condition Expression in the Generate Rows tool to be Date <= [Closing Date]

JonathanSherman_0-1647943619271.png

 

Kind regards,

Jonathan

allwynthomas24
11 - Bolide

Hey @SH_94,

 

Please check the attached workflow and confirm whether it matches your current requirements.

 

Thanks & Regards,

Allwyn

 

Spoiler
allwynthomas24_0-1647946172845.png
Labels