How to create a hierarchy

Justine

Screenshot (161).png

Screenshot (160).png

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

Turribeach

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.

Justine

https://community.dataiku.com/discussion/comment/44027#Comment_44027

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

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.

Justine

Input example.xlsx

Wanted output.xlsx

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.