Two criteria lookup and fetch result

[Srinivasan_C]

Hello All,

This is my first question into the community. I am very new to Alteryx and trying to find if I can solve my complex business data analysis issues.

I want to search based on persons entry date and find the applicable license number as result. Attached file has the example. Please help me with this question. Thanks in advance.

Table 1
Name	Date of Entry
A	3/15/2015
B	6/30/2017
C	7/15/2015
D	7/17/2015
E	1/2/2016

Table 2
Name	License Number	Valid From	Valid To
A	G569324	1/1/2015	12/31/2015
A	J564852	1/1/2016	12/31/2016
B	A235485	1/1/2016	12/31/2016
B	V564875	1/1/2017	12/31/2017
C	H156487	1/1/2015	12/31/2015
C	L785412	1/1/2016	12/31/2016
D	I862457	1/1/2014	12/31/2014
D	W741235	1/1/2015	12/31/2015
E	Q658423	1/1/2015	12/31/2015
E	T129654	1/1/2016	12/31/2016

Result should be
Name	Date of Entry	License Number
A	3/15/2015	G569324
B	6/30/2017	V564875
C	7/15/2015	H156487
D	7/17/2015	W741235
E	1/2/2016	T129654

[PhilipMannering · Accepted solution]

Hey there,

The usual way to solve these problems is to generate all the dates and join. Check the attachment.

Thanks,

Philip

[RolandSchubert · Accepted solution]

Hi @Srinivasan_C ,

you could use Join and a Filter tool to select the date range. I've attached a sample workflow.

Let me know if it works for you.

Best,

Roland 

[Srinivasan_C]

Thanks so much for a super fast reply; when I try to add 'Generate Rows' it shows error Parse error at char (0): Unknown variable "RowCount" can you help me with why I am getting this error?

[Srinivasan_C]

Thank you! It worked for me. I am further customizing it for me.