5 Replies Latest reply on Jan 20, 2017 8:10 AM by Toby Erkson

    How do i split column's data to show first 5 numbers?

    Abed Jaji

      I have a column called RTL_TRANS_ID and I would like to split it's data to show only first 5 numbers. It's data type is VARCHAR2 and I have tableau 10.1.3. Please suggest any possible solutions. Below is the sample data for this column. Thanks!

       

      RTL_TRANS_ID

      00002000032016042800005215

      00002000032016042800005235

      00002000032016042800005278

      00002000032016042800005668

      00002000032016042800005454

      00002000032016042800052125

      00002000032016042802514055

      00002000032016042800002545

      00005000034855858850005455