7 Replies Latest reply on May 16, 2013 3:52 PM by Shawn Wallwork

    Merging 2 or more dimensions

    Richard Khuu

      Hi,

       

      I am looking for a the best solution to all me to merge/group two fields that contain the same data points that are using the same unique id.

       

      For example,

       

      Sample ID| Answer 1 | Answer 2

      Sample 1  | Yes          | No

      Sample 2  | No            | No

      Sample 3  | Yes          | No Answer

      Sample 4  | No Answer |No

      Sample 5  | Yes           |Yes

       

      So in this example I would like group and Sum all the yes, no and no answer for both Answer 1 and Answer 2 fields. Answer 1 and Answer 2 are currently setup as dimensions and data type is string. Sample ID is setup as a dimension as well.

       

      So for Yes we should have 4, No=4 and No Answer= 2.

       

      Any insights into what the best way to do this is.

       

      Thanks,

       

      Richard