Match doesn't work

Neo4j Graph Platform
1

Image -1

vence_andersen1_0-1661513342187.png

Image -2

vence_andersen1_1-1661513370247.png

Image -3

vence_andersen1_2-1661513388666.png

With reference to the above 3 images, all the 3 images have the same query but in the first 2 images we have a match query commented and we are getting the output. The problem is in 3rd image, when I match both suggestion and steps I am not getting the output, can someone explain what's the problem here.

Thanks in advance.

2

You should execute the 'load csv' and return 'line' without the match to make sure the data lines up between 'Suggestions' and 'Steps' to ensure you should have matches for both concurrently. When its done separately, you may be getting output from different lines, but you don't have matches for both one each line. Just a thought, because the syntax looks good.

3

Hi, thanks for your reply, well on using OPTIONAL MATCH

vence_andersen1_0-1661518199546.png

Although p is returning null, it has values

vence_andersen1_1-1661518297963.png

4

Hie, thanks for your reply but it doesn't work. I used "with line" at line 2 and 3, still getting nothing.

vence_andersen1_0-1661517420860.png

5

@vence_andersen1

For the 3rd query after the 1st match add a

with line
6

But I don't get how this impacts the KG from showing the output, as I just wanted those output which matches. Thanks a lot anyways.

7

Or, add 'linenumber() AS number' to your output and run the query with the commented out matches to see if the line numbers are aligned.

8

You should add OPTIONAL on both MATCH I guess and check if the nodes exists with properties you got from your CSV.

9

Can you try OPTIONAL MATCH for the second MATCH?

10

What is the KG?
(migrated from khoros post Solved: Re: Match doesn't work - Neo4j - 59553)

11

I did try OPTIONAL MATCH for both, using "WITH" and without it and got the same below output.

vence_andersen1_0-1661519690234.png

If the nodes have properties? The below snaps are taken after querying using the queries from Image -1 and Image -2 (beginning of the thread) like without matching steps and suggestions simultaneously.

vence_andersen1_1-1661519782642.png

vence_andersen1_2-1661519830241.png

12

You added an "s" to Suggestion and Step whereas there are no "s" on your nodes properties.

13

Hie, yeah that's the first thing I checked, well below is a snap from the CSV.

vence_andersen1_0-1661525139026.png

If what you mentioned is the issue, we shouldn't be seeing outputs even when I don't match steps and suggestions simultaneously, but I am getting output when I match only one at a time.

14

Knowledge Graph.
(migrated from khoros post Solved: Re: Match doesn't work - Neo4j - 59553)

15

Is the intent to use this file to create the data? If so, switch your matches to merges and the missing data will be created and you can continue with your script.