Forum Discussion

GerbenvdHazel's avatar
GerbenvdHazel
Icon for Helper I rankHelper I
6 years ago

Look up value between two dates from different table

Good day, I have two tables. One with trajectories with an end date. The second table concerns relationships where persons working with a start and end date. The dates are not match exactly....
Need Help
Tips and Tricks
GerbenvdHazel's avatar
GerbenvdHazel
Icon for Helper I rankHelper I
6 years ago

Thanks for helping. 
I edit the post with a link to the file.

 

Regards, Gerben

v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi GerbenvdHazel ,

 

So what is the filter that you get companyName, I see you have duplicate Unique personal number value

and duplicate Date start value in  trajectories table.

 

Best Regards,

Dedmon Dai

 

  • GerbenvdHazel's avatar
    GerbenvdHazel
    Icon for Helper I rankHelper I
    6 years ago

    What I'm looking for is a lookupvalue that filters first on Unique personal number and then within the range of dates.

    So end date of the trajectories and then search between date start and end of the placements. And come up with the companyname.

    I hope it is possible.