3 Replies Latest reply on Sep 11, 2018 7:46 AM by Nikhil Sahni

    Why date field appears as a continuous field in tableau

    Nikhil Sahni

      I have created an ODBC connection between Tableau and a database in MarkLogic. The data stored in MarkLogic database is in XML format and I have created template views in order to run SQL on that data. All the elements in my XML document have "String" data type. I am using Custom SQL query in Tableau to bring the data. All the fields show up absolutely fine at the Data Source page. Since the original type for all the fields is the string I am converting the date fields into date time. Now when I go to the sheet and pull the date field on one of the shelves. It brings the CNT(date). I have no idea why is this happening. Please help.