3 Replies Latest reply on Jun 3, 2018 10:45 PM by Sohan Jawar

    Consolidating Multiple Calculated fields into 1

    Benjamin Rubattel

      Hello Everyone,


      I am working a data cleansing with one data provider but in the meantime i am doing some cleansing of this data directly into tableau.


      I have a Reference number that is not entered correctly, for this I use three calulated fields


      1. to get Reference Number 1: Replacing Space and Unwanted Characters


      replace(replace(replace(replace(replace(Replace([Numero de Référence 2],"/",""),"#",""),"~",""),".",""),"-","")," ","")


      2- to ger reference number 2: Keeping the first 10 numbers as they are the one of our reference number


      LEFT(STR([Numero de Reference]), 10)


      My question is, how can I merge both calculation to have only one calculated field?