How to look up fields from another table with multiple condition - inbetween

[balachandra2164]

Hi, 
I have been trying to lookup field from one table to another table with multiple condition where as fields are numeric and string fileds

Could you please help to figure out this in alteryx designer.

Source Table consist two columns : Key column (numeric field) & Source Date

Look Up Table : Key column (numeric) , Lookup_Start_date , Lookup_End_date , Updatedate,Lookup value (numeric)

Condition is :

Key column = Key column 

&

Source Date in between Lookup_Start_date ,Lookup_End_date 

in case multiple values are available , populate look up with latest Updatedate

Souce Table Info:

Look Up Table :

Final Required Table :

note: Date fields are dynamic, always changing ; 

[Sebastiaandb · Accepted solution]

@balachandra2164 

Here is my solution! 

You basically generate dates for each date between start and end of table 2. In that way, you'll have a possible key to match your source date from table 1 :-). Hope it helps! 

Greetings,

Seb