4 Replies Latest reply on Aug 12, 2016 4:24 AM by Sagar Agarwal

    Some String functions not working with HP Vertica 6.1

    Sagar Agarwal

      Hi All,

       

      I am trying to use the some string functions such as SPLIT(), FINDNTH() in Tableau 9.3 <-> HP Vertica 6.1 but getting an Unknown function error (screenshot below). However, the same function works fine with Excel files. Is anyone aware of the issue and how do I fix it?

       

      The Symbol field looks something like this -> (AA,BB,CC,DD,EE,...) => I want to extract the string after the last comma. Any workaround to achieve this?

       

      Tableau_String_Issue_1.png