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?
Solved! Go to Solution.
Views
Replies
Total Likes
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!
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!
Was the given solution helpful to resolve your query or do you still need more help here? Do let us know.
Thanks!
Views
Replies
Total Likes