Child with several parents in hierarchy

EmmelineM

Hi all,

I would like to create a hierarchy with 3 levels of lists: 1. Entity > 2. Direction > 3. Department.
In the level "2. Direction", I want items to belong to several Entities. It is the same for Department level (a Department can belong to several Directions). I need to create a data hub and then a spoke model.

In the picture below you can find an example of my problem:

I don't really know how to populate my 2.Direction list in the spoke model. In my data hub, I've created 3 flat lists: Entity, Direction and Department. I don't know how to roll up my list 2.Direction into my 1.Entity list when it comes to the spoke model.
I was thinking about using a numbered list for both Direction and Department in my spoke model? I don't know how I can export these items from the data hub to the spoke model (I can import them manually, but that is not the point).

Thank you in advance for your answers 🙂

CommunityMember115881

Hi Emmeline,

I suppose it depends on the context and whether the children should be unique or can be assigned simultaneously to various Entities.

In the below example I simply created a numbered list where each child bears the name of a direction (using the display name). 

This is easy to automate using a simple Boolean and an import action.

I hope this helps,

Regards

 

Douglas