1 Reply Latest reply on Oct 16, 2016 12:41 AM by Roger Hau

    Tableau returning string in Google Sheet as a date

    Alex McFarlane

      I have an id field in the format "000000" in a Google Sheet.

       

      It looks something like this:

       

      050105
      051573
      051681
      052081
      052101
      052244
      052455
      052628
      052634
      053361
      041525
      042440
      048573
      049458
      049571
      050777
      050989

      051124

       

      When I connect to this sheet in Tableau (v10.0.0), it converts it into a date.

       

      I can change the data type to string, but it still presents it as a date.

       

      How can I persuade Tableau to treat this as a string? 

       

      thanks for any help!

        • 1. Re: Tableau returning string in Google Sheet as a date
          Roger Hau

          Hey Alex, if you could try a few things, it would help me narrow in the issue:

          • Does writing a calc STR([Id]) generate a string for you?
          • Try downloading the spreadsheet as a .xls and opening it in Tableau. Does the same behavior reproduce?
          • If your organization permits, could you also try 10.0.1?

           

          If you're able to send me the spreadsheet, our team could start investigating it immediately.