7 Replies Latest reply on Feb 8, 2018 8:25 AM by Srinidhi Narayan

    Missing split functionality - MSSQL + ODBC

    Jakub Štěch

      Hello,

       

      I connected MSSQL database via ODBC to Tableau and I want to split a column tha looks like this: AA102 and get only first 3 characters, i.e. AA1. Unfortunately I dont see the split functionality, however the type of the columns is Text.

       

      I did it with calculation (LEFT, 3) but than I was unable to join the data on this column.

       

      Any advise?