5 Replies Latest reply on Apr 26, 2018 7:24 AM by Jim Dehner

    Grouping Multiple Fields

    Nathan Schwinnen

      I am looking for a simple solution to clean data.

      I am working with routing data and I have origins, stops and destinations.  One location may be an origin, stop or destination.  This location may be in my data as multiple names.  For example, I could get the following for one location:

      ABC Company

      A.B.C Company

      A.B.C Company, Inc. 

       

      As is stands now, if this location is an origin, stop and destination, I have create origin (group), stop (group) and destination (group) separately.  I am using thousands of rows of data and there is no way I can keep up with this.  If, however, I could get these all into one field, I might be able to keep up with cleaning the data.

       

      I don't know if this is possible in Tableau, but I'm looking for a way to get all these locations into one field I can clean.