Correctly importing CSV File into Neo4j database










0















I am currently trying to import a csv file into neo4j.
Now for example lets see the following file:



node1,node2
value1,value2
value2,value3
value1,value2


Now what I am trying is to import those lines so that
nodes 1 and 2 will be connected, while identical nodes only exist once.
So I guess I will need to do the MERGE command which seems to work with
the following CQL Request:



LOAD CSV WITH HEADERS FROM "file:///test_text.csv" AS line 
MERGE (u :word value: line.node1 )
MERGE (h :word value: line.node2 )
MERGE (u)-[t :digram]->(h)


Now I want to achieve, that connections between 2 nodes, which occur
multiple times in my csv file (like value1 to value 2 in the example above)
are represented by an attribute "count" in the corresponding connection.
So the connection between value1 and value2 has a attribute count=2.



I have tried to do that by appending the following line:



ON MERGE SET t.count = t.count + 1 ON CREATE SET t.count = 1


But that throws a syntax error. I am kind of lost at the moment and I am hoping
you guys could help.
Thank you very much.










share|improve this question


























    0















    I am currently trying to import a csv file into neo4j.
    Now for example lets see the following file:



    node1,node2
    value1,value2
    value2,value3
    value1,value2


    Now what I am trying is to import those lines so that
    nodes 1 and 2 will be connected, while identical nodes only exist once.
    So I guess I will need to do the MERGE command which seems to work with
    the following CQL Request:



    LOAD CSV WITH HEADERS FROM "file:///test_text.csv" AS line 
    MERGE (u :word value: line.node1 )
    MERGE (h :word value: line.node2 )
    MERGE (u)-[t :digram]->(h)


    Now I want to achieve, that connections between 2 nodes, which occur
    multiple times in my csv file (like value1 to value 2 in the example above)
    are represented by an attribute "count" in the corresponding connection.
    So the connection between value1 and value2 has a attribute count=2.



    I have tried to do that by appending the following line:



    ON MERGE SET t.count = t.count + 1 ON CREATE SET t.count = 1


    But that throws a syntax error. I am kind of lost at the moment and I am hoping
    you guys could help.
    Thank you very much.










    share|improve this question
























      0












      0








      0








      I am currently trying to import a csv file into neo4j.
      Now for example lets see the following file:



      node1,node2
      value1,value2
      value2,value3
      value1,value2


      Now what I am trying is to import those lines so that
      nodes 1 and 2 will be connected, while identical nodes only exist once.
      So I guess I will need to do the MERGE command which seems to work with
      the following CQL Request:



      LOAD CSV WITH HEADERS FROM "file:///test_text.csv" AS line 
      MERGE (u :word value: line.node1 )
      MERGE (h :word value: line.node2 )
      MERGE (u)-[t :digram]->(h)


      Now I want to achieve, that connections between 2 nodes, which occur
      multiple times in my csv file (like value1 to value 2 in the example above)
      are represented by an attribute "count" in the corresponding connection.
      So the connection between value1 and value2 has a attribute count=2.



      I have tried to do that by appending the following line:



      ON MERGE SET t.count = t.count + 1 ON CREATE SET t.count = 1


      But that throws a syntax error. I am kind of lost at the moment and I am hoping
      you guys could help.
      Thank you very much.










      share|improve this question














      I am currently trying to import a csv file into neo4j.
      Now for example lets see the following file:



      node1,node2
      value1,value2
      value2,value3
      value1,value2


      Now what I am trying is to import those lines so that
      nodes 1 and 2 will be connected, while identical nodes only exist once.
      So I guess I will need to do the MERGE command which seems to work with
      the following CQL Request:



      LOAD CSV WITH HEADERS FROM "file:///test_text.csv" AS line 
      MERGE (u :word value: line.node1 )
      MERGE (h :word value: line.node2 )
      MERGE (u)-[t :digram]->(h)


      Now I want to achieve, that connections between 2 nodes, which occur
      multiple times in my csv file (like value1 to value 2 in the example above)
      are represented by an attribute "count" in the corresponding connection.
      So the connection between value1 and value2 has a attribute count=2.



      I have tried to do that by appending the following line:



      ON MERGE SET t.count = t.count + 1 ON CREATE SET t.count = 1


      But that throws a syntax error. I am kind of lost at the moment and I am hoping
      you guys could help.
      Thank you very much.







      csv import neo4j






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 12 '18 at 22:56









      marcels93marcels93

      162




      162






















          1 Answer
          1






          active

          oldest

          votes


















          2














          Just a small error here, it's ON MATCH SET, not ON MERGE SET.






          share|improve this answer























          • Well... im feeling pretty stupid now, but it perfectly worked :D So thank you very much.

            – marcels93
            Nov 13 '18 at 0:11











          Your Answer






          StackExchange.ifUsing("editor", function ()
          StackExchange.using("externalEditor", function ()
          StackExchange.using("snippets", function ()
          StackExchange.snippets.init();
          );
          );
          , "code-snippets");

          StackExchange.ready(function()
          var channelOptions =
          tags: "".split(" "),
          id: "1"
          ;
          initTagRenderer("".split(" "), "".split(" "), channelOptions);

          StackExchange.using("externalEditor", function()
          // Have to fire editor after snippets, if snippets enabled
          if (StackExchange.settings.snippets.snippetsEnabled)
          StackExchange.using("snippets", function()
          createEditor();
          );

          else
          createEditor();

          );

          function createEditor()
          StackExchange.prepareEditor(
          heartbeatType: 'answer',
          autoActivateHeartbeat: false,
          convertImagesToLinks: true,
          noModals: true,
          showLowRepImageUploadWarning: true,
          reputationToPostImages: 10,
          bindNavPrevention: true,
          postfix: "",
          imageUploader:
          brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
          contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
          allowUrls: true
          ,
          onDemand: true,
          discardSelector: ".discard-answer"
          ,immediatelyShowMarkdownHelp:true
          );



          );













          draft saved

          draft discarded


















          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53271298%2fcorrectly-importing-csv-file-into-neo4j-database%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown

























          1 Answer
          1






          active

          oldest

          votes








          1 Answer
          1






          active

          oldest

          votes









          active

          oldest

          votes






          active

          oldest

          votes









          2














          Just a small error here, it's ON MATCH SET, not ON MERGE SET.






          share|improve this answer























          • Well... im feeling pretty stupid now, but it perfectly worked :D So thank you very much.

            – marcels93
            Nov 13 '18 at 0:11
















          2














          Just a small error here, it's ON MATCH SET, not ON MERGE SET.






          share|improve this answer























          • Well... im feeling pretty stupid now, but it perfectly worked :D So thank you very much.

            – marcels93
            Nov 13 '18 at 0:11














          2












          2








          2







          Just a small error here, it's ON MATCH SET, not ON MERGE SET.






          share|improve this answer













          Just a small error here, it's ON MATCH SET, not ON MERGE SET.







          share|improve this answer












          share|improve this answer



          share|improve this answer










          answered Nov 13 '18 at 0:04









          InverseFalconInverseFalcon

          18.8k21829




          18.8k21829












          • Well... im feeling pretty stupid now, but it perfectly worked :D So thank you very much.

            – marcels93
            Nov 13 '18 at 0:11


















          • Well... im feeling pretty stupid now, but it perfectly worked :D So thank you very much.

            – marcels93
            Nov 13 '18 at 0:11

















          Well... im feeling pretty stupid now, but it perfectly worked :D So thank you very much.

          – marcels93
          Nov 13 '18 at 0:11






          Well... im feeling pretty stupid now, but it perfectly worked :D So thank you very much.

          – marcels93
          Nov 13 '18 at 0:11


















          draft saved

          draft discarded
















































          Thanks for contributing an answer to Stack Overflow!


          • Please be sure to answer the question. Provide details and share your research!

          But avoid


          • Asking for help, clarification, or responding to other answers.

          • Making statements based on opinion; back them up with references or personal experience.

          To learn more, see our tips on writing great answers.




          draft saved


          draft discarded














          StackExchange.ready(
          function ()
          StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53271298%2fcorrectly-importing-csv-file-into-neo4j-database%23new-answer', 'question_page');

          );

          Post as a guest















          Required, but never shown





















































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown

































          Required, but never shown














          Required, but never shown












          Required, but never shown







          Required, but never shown







          Popular posts from this blog

          Use pre created SQLite database for Android project in kotlin

          Darth Vader #20

          Ondo