How can I lookup a variable based on another table

Question

Hello,

I have two tables and not sure how to go about it. Below is a snapshot of my 1st table (data) but I am trying to find the Weeks Out.

The 2nd table has the Weeks Out. The Weeks Out Date is the week it starts so if the Date is within the week of the weeks out date then the corresponding weeks out is populated.

SessionDateWeeks Out2025317/11/2024 2024357/10/2024 2024357/9/2024 2025117/8/2024 2025117/7/2024 2025117/6/2024 2025117/5/2024 2025117/4/2024 2025117/3/2024 2025117/2/2024 2025117/1/2024 2025116/30/2024 2025116/29/2024 2025116/28/2024 2025116/27/2024

Here is my 2nd table:

SessionStart Date2End Date2ModelWeeks OutWeeks Out DateData Through2024356/24/20248/18/2024last 3 5's06/24/20246/23/20242024356/24/20248/18/2024last 3 5's16/17/20246/16/20242024356/24/20248/18/2024last 3 5's26/10/20246/9/20242024356/24/20248/18/2024last 3 5's36/3/20246/2/20242025118/26/202410/20/2024last 3 1's47/29/20247/28/20242025118/26/202410/20/2024last 3 1's57/22/20247/21/20242025118/26/202410/20/2024last 3 1's67/15/20247/14/20242025118/26/202410/20/2024last 3 1's77/8/20247/7/20242025118/26/202410/20/2024last 3 1's87/1/20246/30/20242025118/26/202410/20/2024last 3 1's96/24/20246/23/20242025118/26/202410/20/2024last 3 1's106/17/20246/16/20242025118/26/202410/20/2024last 3 1's116/10/20246/9/20242025118/26/202410/20/2024last 3 1's126/3/20246/2/202420251510/21/202412/15/2024last 3 5's127/29/20247/28/202420251510/21/202412/15/2024last 3 5's137/22/20247/21/202420251510/21/202412/15/2024last 3 5's147/15/20247/14/202420251510/21/202412/15/2024last 3 5's157/8/20247/7/202420251510/21/202412/15/2024last 3 5's167/1/20246/30/202420251510/21/202412/15/2024last 3 5's176/24/20246/23/202420251510/21/202412/15/2024last 3 5's186/17/20246/16/202420251510/21/202412/15/2024last 3 5's196/10/20246/9/202420251510/21/202412/15/2024last 3 5's206/3/20246/2/20242025211/6/20253/2/2025last 3 1's237/29/20247/28/20242025211/6/20253/2/2025last 3 1's247/22/20247/21/2024

OTrieger · Answer

Hi @bryanmac_92

Actually not sure which is the easiest way, however you will need to use Session as the point to combine the data

Join the data based on session and then check the days difference between Date and  Week Outs and then filter out based on a bracket of 7 days.