5 Replies Latest reply on Aug 20, 2018 11:38 AM by Deepak Rai

    Distinct Count of Values in a Concatenated String Using Calculated Fields

    Philippa Lehar

      I have a data set that looks like this:

      Document

      Universities

      A

      University of Chicago, University of Minnesota, University of Chicago, University of Chicago, Smith College, Smith College

      B

      Colorado State University, Colorado State University, Stanford University, UMass Amherst, Stanford University, Connecticut College, Northwestern University

      C

      UCSC, UCSC

      D

      State College, Carnegie Mellon University, State College, State College

       

      I would like to be able to count the number of unique values in the concatenated [Universities] field. Does anyone know an easy way to do this with calculated fields to get the following result?

      Document

      Universities

      Distinct Ct of Universities

      A

      University of Chicago, University of Minnesota, University of Chicago, University of Chicago, Smith College, Smith College

      3

      B

      Colorado State University, Colorado State University, Stanford University, UMass Amherst, Stanford University, Connecticut College, Northwestern University

      5

      C

      UCSC, UCSC

      1

      D

      State College, Carnegie Mellon University, State College, State College

      2

       

      Thanks!