2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Alteryx Designer Discussions

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

Matching the date in between both dates

SH_94
10 - Fireball

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
10 - Fireball

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