0 Replies Latest reply: Feb 8, 2016 7:55 AM by Nepumuk Berger RSS

    How to assign elements to hierarchized groups?

    Nepumuk Berger

      Hello everyone!

       

      My question concerns the following task:

       

      I have a list with different elements and their specific properties (Table1).

      ElementPropertyProperty_Value
      E1a3
      E1b1
      E1c1
      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.

      GroupRequired_Property
      G1a>=3
      G2a>=2
      G3a>=1
      G4b>=2
      G5b>=1
      G6y>=0,5
      G7c>=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 AColumn B
      G1G2
      G1G3
      G2G3
      G4G5
      G6G7

       

      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