Hello everyone!
My question concerns the following task:
I have a list with different elements and their specific properties (Table1).
| Element | Property | Property_Value |
|---|
| E1 | a | 3 |
| E1 | b | 1 |
| E1 | c | 1 |
| E2 | ... | |
These elements should now be assigned to groups with defined requirements (Table2). Depending on the individual properties it is possible that one element meets the requirements of more than one group.
| Group | Required_Property |
|---|
| G1 | a>=3 |
| G2 | a>=2 |
| G3 | a>=1 |
| G4 | b>=2 |
| G5 | b>=1 |
| G6 | y>=0,5 |
| G7 | c>=1 |
Anyhow the groups are partial hierarchized, what means that one element must not be assigned to more than one group in the same hierarchy but has to be matched with the group with the highest hiearchy-level.
The hierarchy of the groups is provided in the following structure (Table3):
| Column A | Column B |
|---|
| G1 | G2 |
| G1 | G3 |
| G2 | G3 |
| G4 | G5 |
| G6 | G7 |
If one element meets the requirements of two groups in one row of Table3 it has to be assigned to the group in column A.Thus there are three hierarchies (H1 with G1, G2, G3; H2 with G4, G5; H3 with G6, G7).
So in this example Element E1 should be asigned to group G1, G5 and G6.
The goal is to assign every element to its fitting groups.
As a sophomore in the world of QV I'm kind of overstrained with this task and have no idea where to start. Existing threads to hierachy function weren't that helfpul for me.
I would be very grateful for any kind of help!
Greetings,
nepberger
