1 Reply Latest reply on Jul 18, 2018 8:51 AM by Jim Dehner

    Can you add letter/number to your data in Tableau Prep?

    Pratichi Dash

      Sometimes we get zipcodes from vendors which are 4 digits, which means that they are missing a trailing "0". Can we perform add functionalities within Prep? Like add a zero at the end or front?

        • 1. Re: Can you add letter/number to your data in Tableau Prep?
          Jim Dehner

          Hi

          the short answer is Yes - but the question is how is the zip code cast as it comes into Prep - is ti a Str or a Number?  if you want 5 digit zips suggest you convert it to a string

           

          Then you can use a formula like right (('0'+[zip]),5) 

           

          it will form a nue measure

           

          Jim

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.