4 Replies Latest reply on Sep 21, 2017 9:13 AM by Joe Oppelt

    How do you remove characters from a column?

    Shaun Flateau

      Hi everyone,  I am brand new to Tableau and I am trying to join two different databases on an agent name.

       

      Example, I have a Agent Name in one database that is "John_Smith1" and in the other database it is "Partners_TP_.John_Smith1"  we have about 300 agents we need to get rid of that "Partners_TP_." part so we can have that true match. Can someone explain or show me some kind of tutorial that is out there on how you would do that?