Child with several parents in hierarchy
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 🙂