2 Replies Latest reply on Mar 24, 2015 4:47 AM by kettan

    What is the correct schema.ini specification for this data?

    Ryan Knight

      Howdy,

       

      I am having trouble getting the my schema.ini files to work correctly. Tableau is interpreting my dates as null, no matter what I seem to do. The data looks like this:

       

      StudentID,LogDate,LogEntry,LoggedBy

      "1234","9/8/2014","asdf","66888"

      "12345","9/25/2014","asdf","67839"

      "12435","9/5/2014","asdf","66875"

      "99999","11/14/2014","asdf","66875"

      "112211","8/25/2014","asfd","66875"

       

      My schema.ini file is:

       

      [Thisfile.csv]

      Format=CSVDelimited

      ColNameHeader=True

      DateTimeFormat = mm/dd/yyyy

      TextDelimiter="

      Col1=StudentID long

      Col2=LogDate Date

      Col3=LogEntry text

      Col4=LoggedBy long

       

      Am I making a stupid mistake somewhere? I have also tried mm-dd-yyyy, upper case versions, versions in quotes... not sure what to do here.

       

      Many thanks.