2 Replies Latest reply on Oct 19, 2018 9:47 AM by Daniil Saiko

    Inherit Value

    Daniil Saiko

      I have data which is missing certain parameters at the individual level but can be inherited or inferred from the group.

       

      The assignee will always be the same for the group, but not all fields will have that value. This occurs because data comes from the different source and one source lacks that data point. When it is not all the same value the group does not display all elements in it when filtered by Assignee. The relationship is that Assignee can be related to many Groups. How do I add value to all items with a unique ID to have the same Assignee as the group they are part of.

       

      Start

      GroupIDValue1Assignee
      11100NULL
      12200a
      23300b
      24100NULL
      25200b

       

      Final

      GroupIDValue1AssigneeResolved
      11100NULLa
      12200aa
      23300bb
      24100NULLb
      25200bb