Forum Discussion

patrick3's avatar
patrick3
Helper II
6 years ago

Return value based on Date / Key pair

Hi all,   I've got 2 tables:   Date Unique Key Value 01/01/2019 abc123 5 01/02/2019 abc123 10 01/01/2019 abc456 5 01/02/2019 abc456 10   Date Unique Key Value ...
Need Help
az38's avatar
az38
Community Champion
6 years ago

hi patrick3 

why for abc456 in table 2 returns 5, not 10 (newest in table 1 that older then abc456)?

 

do not hesitate to give a kudo to useful posts and mark solutions as solution