How can I add a condition in "SIMILARITY"

Neo4j Graph Platform Graph Algorithms/Graph Data Science
1

Excuting the query of similarity was successuful by using this :

MATCH (at1:Attrib)<-[r:ASSIGNED]-(c:Contrat)-[x:ASSIGNED]->(at2:Attrib)
MERGE  (at1)-[s:SIMILARITY]-(at2)

And then , to display only Attribs which are working together , I worked with this query and it's fine :

MATCH (at:Attrib)<-[r]-(c:Contrat)
WITH DISTINCT c.id AS Contrat , collect(DISTINCT at.label) AS Attributaires, count( DISTINCT at.id) AS Count
Return  Attributaires;

and this the result :

image
image.png1277×299 12.3 KB

My question is how can I remove duplicates for "at" in the graph and not only in the list . if 2 at have the same ID and they re displayed then we display only one at .

2

I'm not sure that I understand exactly what you'd like to do...could you maybe share a sample dataset that I can create locally and then say what you'd like the output of your query to be?

3

Actually this is the graph that I obtained after excuting "similarity" .

image
image.jpg931×724 60.1 KB

And here is the list of "Attributes" which are working together :
image
image.png1291×280 12.8 KB

What I want to do exactly is : deleting the duplicates nodes which have the same ID (ID : 111 apearing twice for example here in the graph , I want to havejust one instead of two nodes with the same ID .

4

Here is the solution :