8 Replies Latest reply on Oct 29, 2018 3:44 PM by Don Wise

    Mismatched customer names in a union

    Jacob Rogers

      I have a union of two datasources, each of which has a Customer Name dimension. But ds1 is simply 'Last, First' and ds2 is 'Last, First MI' (if there is a middle initial).

       

      Is there a way to tell Tableau to treat 'Smith, John A' the same as 'Smith, John' for purposes of the union?

       

      If not, then I need to strip any middle initials, which I suppose enters regex territory? If so, can anyone help with that expression?

       

      Thanks!