3 Replies Latest reply on Jan 28, 2020 7:47 AM by Corey Malone-Smolla

    Join Calculation Else and IF

    Corey Malone-Smolla

      Hi! I worked with a Tableau Service Corps member to join my data. We realized my two county columns were not matching because some were written as York County and the other just York as . My service corps member wrote this join calculation below and it worked. I've realized however that a few other endings are getting in the way of having this work out including:

       

      Parish

      Borough

      Municipality

      Census Area

       

      What would be the way to modify this to do the exact same thing my service corps member did but to incorporate the ones above?

       

      If CONTAINS([County], 'County') then

      TRIM(

      LEFT([County],FIND([County],'County') -1))

       

      ELSE

      TRIM(

      LEFT([County],FIND([County],'Municipio') -1))

       

       

      END