Fructose | A Ruby-like language that compiles to PHP

You need to create a list and append to it. Currently, you are just overwriting with the last value.

I have tried description and [description] but it throws an error saying that decription has been used more than once.

This is due to your name of property decription is duplicate, you can try this sql:

First, I see no error in your JSON other than you have a spelling error ("b": "glyceraldehde"). So there must be some other issue. The following almost does the job:

try with preg_match:

You could use strsplit and add a group column according to list number, finally rbind the thing.

So basically you want to replace the numeric keys on the merkmale -> gruppe level with the name of the item? Then this should do:

using

You don't explain how you plan on merging the last dataset that has no common key(s) with any of the other datasets, so I will omit the fourth dataset in the following example.

To merge the three datasets, we can use dplyr::full_join which performs a full outer join and automatically picks up and merges entries by common keys.

[UPDATED]

There are multiple issues and possible improvements:

1. The second MERGE should be deleted, since it creates orphaned nodes. A relationship type should not be tuned into a Glycolysis node, and such nodes would never be connected to any other nodes.
2. The 1st and 3rd MERGE clauses must use the same property name (say, name) for source and target nodes, or else the same chemical can end up with 2 nodes (with different property keys). This is why you ended up with nodes that did not have all the expected connections.
3. The APOC procedure apoc.cypher.doIt can be used to simplify somewhat the MERGE of relationships with dynamic names.
4. The glycolysis_bioentities.csv is not needed for this use case.

With the above changes, you end up with something like this, which will generate a connected graph that matches your input data: