You can translate the question and the replies:

Dendo Design Studio's problem with Neo4J

Hello Team, I'm using Denodo 8 via Web Design Studio. I created the Neo4j datasource via HTTP configuration with post method, also making use of a Json file. I inserted the fields via the following source query: \{"statements": [ \{ "statement": "MATCH p=(a)-[r:X]->(b) RETURN a.A as A, a.B as B, b.C as C, b.D as D"\}] \}. Once the base view has been created, when I go to create the flatten file I cannot flatten it because I don't get the icon (point 2 of the following link: https://community.denodo.com/tutorials/browse/basics/3adv2flatten) to flatten the array. Thanks
Derived views Neo4j flatten FLATTEN WEB design Studio Array JSON JSON Datasource
user
22-11-2022 09:38:28 -0500
code

1 Answer

Hi, It is possible to use flattening on hierarchical structures and Denodo supports two different complex data types at the moment which are Registers and Arrays. For more details, please find [this link](https://community.denodo.com/tutorials/browse/basics/3adv2flatten). The statement in your initial question is showing that it will return only 4 fields (a.A, a.B, b.C and b.D) with the relationship of p=(a)-[r:X]->(b). It is possible that the flatten button is not activated when the design studio cannot find anything to be flattened. I would verify the base view by executing it and see the result set returned from neo4j to see if the resultset needs to be (can be) flattened or not. Hope this helps.
Denodo Team
24-11-2022 03:06:10 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here