How to create a hierarchy
Hello,
I would like some help to create a hierarchy. Indeed, I have some issues to create one. I have a a raw file such the way explained on the raw excel data (colored) with parents and child IDs and Names and I would like to be able to get 3 tables : One with all the parent and child name, one with all their ID and one linked to the last one which would show their parent. How would you do that under Dataiku?
Thanks a lot in advance for your help.
Justine
Answers
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,059 Neuron
What kind of solution are you looking for? Code Recipe or Visual Recipe? Where do you store your data? Do you have access to a SQL database? Most SQL databases have specific functions to deal with hierarchies.
-
Hi, Thanks for your answer. I am looking for a visual recipe solution. I store the data on a client environment and I don't have any local one and I don't have any access to a SQL Database.
-
Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,059 Neuron
Can you please post an Excel workbook with sample input data and sample outputs as you want to get them. That will allow people to see if they can replicate the outputs you want using a visual recipe.
-
Hi, this is an instance of the input and output I would like to obtain. I need to show a parent table and a table mixing parent and child which are linked to their parent.