Multiple Return Values based on Specific Dates

Question

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

Entry Date Sample.xlsx

Sample Forum Question.xlsx

Criteria Sample.xlsx

gautiergodard · Accepted Answer

Hello @GreenApple24

Please see attached for a proposed solution to this problem!

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