Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
We’re experiencing technical issues with our vendor that are affecting license activations for Designer Desktop. We don’t yet have an estimated resolution time. We apologize for the inconvenience and will share updates as we have them.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Multiple Return Values based on Specific Dates

GreenApple24
6 - Meteoroid

Hey All,

I am new to Alteryx and am currently stuck on a simple problem.

I have a workbook with a column that lists out entry dates. I have another workbook with a range of start / end dates. If the Entry date falls between the start and end date, then I am looking to return the Product IDs. There can be multiple Product IDs for multiple rows of entry dates. For example Cell I3 returns Product A and B and D. Is there a way to perform this in Alteryx? I have already joined the two workbooks based on the Joining Factor Criteria. 

GreenApple24_0-1665771483325.png

 



Thanks in advance for the help!
GreenApple24

2 REPLIES 2
gautiergodard
13 - Pulsar

Hello @GreenApple24 

Please see attached for a proposed solution to this problem!

 

Please mark the post as resolved if this answers your question :)

GreenApple24
6 - Meteoroid

Yup that got it. Thanks for the quick response!

Labels
Top Solution Authors