5 Replies Latest reply on Mar 26, 2018 8:32 AM by Matt Bechard

    Type Conversion Issue from string to date [Splunk - Tableau connection via splunk ODBC driver]

    prasad puranik

      Hi

      We are importing data (Date and Count columns) in tableau desktop 8.0 from splunk via splunk ODBC driver.


      The problem is we are not able to do incremental refresh using Date column as the type of Date column is string in splunk.

       

      We have tried below options but nothing is working out for us.

       

      1) We have tried to change type of Date column from string to date in tableau, but still we are not able to incremental refresh and
      tableau is throwing an error something  like could not compare string with date


      2) We have created calculated field in tableau for the Date colunm in tableau. But we are unable to use it as an incremental key.


      3) We have tried to change the type of Date column from string to date in splunk, but we believe such option is not
      available in splunk, we can only format the Date column's value in splunk