Cpher Query to relate Two Nodes under same level

Neo4j Graph Platform Cypher
1

Have create two nodes

'Individual_Hist_table' is acting as Input to built 'Record_Hist_details'

CREATE (hist:History { name: 'Record_Hist_details' , type : 'Daily'})
CREATE (hist:History { name: 'Individual_Hist_table' , type : 'Daily'})

when am executing below query its not creating a relationship which originate from Individual_Hist_table and end at Record_Hist_details

Match (hist:History { name: 'Individual_Hist_table'}) , (hist: History { name: 'Record_Hist_details'})
Create (hist)-[:Built_Using]->(hist)

2

You are using the 'hist' variable to bind to both nodes. Try the following:

Match (hist1:History { name: 'Individual_Hist_table'}) , (hist2: History { name: 'Record_Hist_details'})
Create (hist1)-[:Built_Using]->(hist2)
3

Thank you so much this worked

If we have Job level dependencies can we draw a lineage @ Table and column level using Neo4j

Stg 1 /Stg2 ----> Tgt 1
Tgt 1 ---> Join with Stg3 ---> Tgt 2 and so on

4

Sorry, I don't understand your request. Can you give me an example?