![almastanul almastanul](https://community.neo4j.com/legacyfs/online/3X/7/9/790292e9b6a49cb815799624c55f22e26a9df9e7.jpeg)
‎09-29-2021 01:31 AM
Here you can see all nodes connected with a single ID but when try to apply Cypher query to
merge all data and export as table form it is not working.
I have used a match query but the data is not showing correctly.
My expected output in CSV will be here mention one data example likewise need to export
more dataset in csv.
My expected output will be in csv
|PMID| AU| copyright| pub| Citation| country|
|2690338| Singer M|Med Inten..| Medline| 4271| United states|
Solved! Go to Solution.
- Labels:
-
Cypher
‎09-29-2021 04:43 AM
It should work with this query, feel free to update the RETURN
clause:
MATCH (a:id)-[By_copyright]->(b:copyright), (a)-[has_pub_type]->(c:pub), (a)-[Having_citation]->(d:citation), (a)-[By_author]->(e:author), (a)-[Drom_country]->(f:country)
RETURN a, b, c, d, e, f
‎09-29-2021 04:19 AM
Hello @almastanul and welcome to the Neo4j community
It is not clear what you expect as result. Can you give us an example of the output you expect?
Regards,
Cobra
‎09-29-2021 04:43 AM
It should work with this query, feel free to update the RETURN
clause:
MATCH (a:id)-[By_copyright]->(b:copyright), (a)-[has_pub_type]->(c:pub), (a)-[Having_citation]->(d:citation), (a)-[By_author]->(e:author), (a)-[Drom_country]->(f:country)
RETURN a, b, c, d, e, f
![almastanul almastanul](https://community.neo4j.com/legacyfs/online/3X/7/9/790292e9b6a49cb815799624c55f22e26a9df9e7.jpeg)
‎09-29-2021 05:39 AM
It is showing no changes, no records.
‎09-29-2021 05:42 AM
There is a typo in my query, check every node label and every type of relationship.
![almastanul almastanul](https://community.neo4j.com/legacyfs/online/3X/7/9/790292e9b6a49cb815799624c55f22e26a9df9e7.jpeg)
‎09-29-2021 06:54 AM
Thanks @Cobra it is working after correct typo mistake in relationship.
![](/skins/images/DCEE200A061243D9CDD43EC39D921EED/responsive_peak/images/icon_anonymous_message.png)