Create an edge with timestamp property between two existing nodes

Neo4j Graph Platform Cypher
1

image
image2628×1775 212 KB

How can I create an edge with timestamp property between two existing nodes ? for example in the above digram I would like to create an edge between VitalSign node and ICUStay node. the common column between the two nodes is Subject_id. I would like to create a timestamp of one day(24hours) as property of the edge. The timestamp to determine 24 hours after the icu stay admission

Thanks in advance for the help

2

You can find both nodes by subject-id.

MATCH (icu: ICUStay { Subject_id: $Subject_id})
MATCH (vital: VitalSign { Subject_id: $Subject_id})
CREATE (icu}-[rel:CHECKED]->(vital)
SET rel.timestamp = icu.admission + duration('P1D')