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
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.
Solved! Go to Solution.
Hi @SH_94,
If we generate the rows required we can join on the OJD and date fields:
Output A:
Output B:
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
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.
Hi @SH_94,
You'll want to change the Condition Expression in the Generate Rows tool to be Date <= [Closing Date]
Kind regards,
Jonathan