Getting data in one table using data of another table using enrichment

[SmritiFotedar]

Hi everyone, I have two tables ( History and other is recipient). History schema has attributes- booking date, nameid and tour cd while Recipient has attribute - nameId,lastTourCode and LastTourDate. So, in My history worklfow, i want to implement a use case in which i have recipient's last tourDate should be equal to the latest booking date ( booking date is present in history schema) and recipients LastTourCode should be equal to the tour code corresponding to the latest booking date. 
I am unable to this, after update activity , when i am using enrichment and selecting nameid (for grouping records) and then using aggregate function to get the maximyum booking date , it is giving me zero records. 

Can anyone help?

[Kishore_Padamata · Accepted solution]

Hello @SmritiFotedar 
Have you tried with RowNum function
https://experienceleague.adobe.com/docs/campaign-standard/using/managing-processes-and-data/filterin...
@rank as RowNum(PartitionBy(<recipient identifier>), OrderBy(Desc(<booking date>)))

Then, filter @rank = 1

Hope this helps!

[Sukrity_Wadhwa]

Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.

Thanks!