Multiple Return Values based on Specific Dates

[GreenApple24]

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. 

Thanks in advance for the help!
GreenApple24

[gautiergodard · Accepted solution]

Hello @GreenApple24 

Please see attached for a proposed solution to this problem!

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

[GreenApple24]

Yup that got it. Thanks for the quick response!