2 Replies Latest reply on Mar 29, 2020 12:04 PM by avi.chin

    Convert SQL to Tableau formula

    avi.chin

      Hi,

       

      I need some help converting this SQL to a tableau formula.

       

      LEFT(LTRIM(RTRIM(cast(COLUMNA as varchar(1000)))),LEN(COLUMNB))

       

      LEFT(LTRIM(RTRIM(SUBSTRING( LTRIM(RTRIM(CAST(COLUMNA as varchar(1000)))) , LEN(COLUMNC) + 1  ,LEN(cast(COLUMNA as varchar(1000)))-  (LEN(@COLUMNC) + 1)  ))),LEN(COLUMNB)