title: How to make relationship between two nodes from different json file based on matching property value?
body: <p>I'm using neo4j 4.3.2 version. I have two json files. I want to match and create relationship from first json to second json file based on the matching property between nodes from two json files. Please have look on the json file:</p>
  <p>First Json as follows:</p>
  <pre><code>{&quot;id&quot;:&quot;123&quot;}
  </code></pre>
  <p>Second Json as follows:</p>
  <pre><code>&quot;member&quot;: [
      {
          &quot;Authority&quot;: &quot;xy&quot;,
          &quot;Number&quot;: &quot;999&quot;,
          &quot;Code&quot;: &quot;Z2&quot;,
          &quot;Date&quot;: &quot;1986-06-12&quot;,
          &quot;Publication&quot;: &quot;123&quot;
      }]
  </code></pre>
  <p>I want to match all nodes from first json which have property &quot;id&quot; value 123---&gt;second json with all matching property &quot;publication&quot; value &quot;123&quot; and link them.</p>
  <p>Below is code I have tried but , it shows &quot;(no changes, no records)&quot;. What change i have make here in order to make it right. Hope for valuable suggestions.</p>
  <p>Cypher query I have tried:
  Load First Json</p>
  <pre><code>CALL apoc.load.json (&quot;file:///D:/first.json&quot;) YIELD value AS data merge(a:LabelA{A:data.id})
  </code></pre>
  <p>Load Second Json</p>
  <pre><code>CALL apoc.load.json (&quot;file:///D:/second.json&quot;) YIELD value AS dataFOREACH (idn IN data.member | MERGE(b:LabelB{Number:idn.Number})ON CREATE SET b.Publication=idn.Publication)
  </code></pre>
  <p>Tried to Match and create Relationship</p>
  <pre><code>create index on :LabelA(id);create index on :LabelB(Publication);MATCH (a:LabelA) 
  MATCH(b:LabelB)WHERE b.Publication = a.id merge (a)-[:lin]-&gt;(b)     
  </code></pre>
  <p>It shows &quot;(no changes, no records)&quot;</p>
  <p>Any suggestion would be great help.</p>
  <p>Thank you</p>