Requirement:- I need to do a lookup on Object and say we get 3 records from this Lookup, now I need to do a lookup on Date Range to get the correct Area.
Code: Select all
Look Up File
OBJECT,Date_From,Date_To, AREA
1234 ,20070101 ,20071231, A1
1234 ,20080101 ,20081231, A2
1234 ,20090101 ,20091231, A3
Source File
OBJECT, Date
1234 , 20080201
Desired Result
OBJECT,Date , Area
1234 ,20080201, A2
Thanks in Advance.
Have a great day!