6 Replies Latest reply on Jan 8, 2019 1:17 PM by Peter Fakan

    Combine two values "answers" into one "answer" in a field?

    Alexandra Statham

      Some of my data has various answers that ultimately mean the same thing. But Tableau treats them as different answers just because they're spelled differently.

      Example:
      2-WKS
      2 WKS
      gets treated as different answers on a graph because of the dash "-" character. Is there anyway to combine this and tell Tableau to treat it as the same answer?

      I'm dealing with password-locked spreadsheets and all kinds of other nonsense, so I can't just go into the spreadsheet and do a "replace all" to clean up the data source.