How to group by and get the latest record with column combination

Neo4j Graph Platform Cypher
1

i have a node with few columns and below are few of the results in it

Email1 Email2 ContactDateInStr
abc@test.com xyz@test.com 20190604
abc@test.com xyz@test.com 20190512
suv@test.com abc@test.com 20190604
def@test.com xyz@test.com 20190515

The result should be below where i am considering combination of Email1 and Email2 and taking only latest date(string) .

Email1 Email2 ContactDateInStr
abc@test.com xyz@test.com 20190604
suv@test.com abc@test.com 20190604
def@test.com xyz@test.com 20190515

any suggestion?

2

Yes, after the match, after you've projected out variables, just use the max() aggregation.

...
WITH email1, email2, max(contactDateInStr) as latestDate
...

Aggregations are with respect to the non-aggregation variables which become the grouping key, so this is the max contact date string per each distinct email1, email2 combination.

2 Likes
3

Yes , this would work if i just need the combination and max of date. Thanks!

4

hello everyone, I have a final result see below.. here i have UNION matched the 2 queries. but i required only the last result based on the nodetype. how to do this ??

label value nodetype
"App-PolicyManagement" "App-PolicyManagement" "Application"
"App-CustomerManagement" "App-CustomerManagement" "Application"
"SSMAP" "SSMAP" "Screen"