4 Replies Latest reply on Jan 23, 2019 3:24 PM by Deepak Rai

    Summing String Fields using a break column

    Crystal Theaker

      If I have the following data:

       

      EmployeeIDLocation
      1234BldgA
      1234BldgB
      1235BldgB
      1235BldgC
      1236BldgA
      1236BldgB
      1236BldgC
      1236BldgD
      1237BldgA
      1238BldgA
      1238BldgC
      1239BldgD
      1240BldgA
      1240BldgD

       

      I would like a summation of each of the locations the employee has access to into a field.

      For instance I would want a calculated field such as:

       

      EmployeeIDLocation
      Calculation
      1234BldgABldgA, BldgB
      1234BldgBBldgA, BldgB
      1235BldgBBldgB, BldgC
      1235BldgCBldgB, BldgC
      1236BldgABldgA, BldgB, BldgC, BldgD
      1236BldgBBldgA, BldgB, BldgC, BldgD
      1236BldgCBldgA, BldgB, BldgC, BldgD
      1236BldgDBldgA, BldgB, BldgC, BldgD
      1237BldgABldgA
      1238BldgABldgA, BldgC
      1238BldgCBldgA, BldgC
      1239BldgDBldgD
      1240BldgABldgA, BldgD
      1240BldgDBldgA, BldgD

       

      Is this a possibility?