Export of TDSX files: Time stamps have only hours 1 - 12

Comments

5 comments

  • Official comment
    Joel Stewart

    Thanks for the clarification Michael. Based on this feedback, I was able to reproduce this issue and have created a defect (DAP-26230) for this issue to get resolved in a future release. It's unclear from this test if the issue lies within Datameer or Tableau directly, but we'll get to the bottom of it.

    As a work-around, I was able to use the FORMATDATE function to cast the DATE type columns to a STRING type column. 

    This issue will be resolved in 5.10.14, 5.11.8 and later revisions of Datameer.

    Comment actions Permalink
  • Joel Stewart

    Could you please elaborate a bit on the configuration?

    Is the affected column a DATE type column or a STRING type column?

    Where and how are you specifying the date format? During an export to TDSX (or Download) the DATE type column should not require any manual formatting. The formatting of DATE type columns to TDSX format should be automatic.

    0
    Comment actions Permalink
  • Michael Ahn

    It is a DATE column. I did not change the format manually, I just documented what is shown in the export table view.

    0
    Comment actions Permalink
  • Joel Stewart

    By the Export Table view, I assume that you mean the "Mapping" stage of the Export Job configuration wizard. Is that correct? 

    This page only displays a few rows as a sample and is not the entire dataset. If this display doesn't contain hours 13-23 nor 00, that is not surprising. I do expect that all entries are exported to Tableau correctly though.

    As a test, it may be a good idea to create a filter for events only in a certain hour (i.e. 1300 or 1:00 PM) and then export these results to Tableau. In this case, the sample results should include these entries exclusively and these should be easily validated in Tableau after receiving the TDSX file. 

    0
    Comment actions Permalink
  • Michael Ahn

    Yes, I know that. I exported data for a whole month with time stamps every 15 seconds. When I import the file to Tableau I find only hours 1-12, no 13-23

    0
    Comment actions Permalink

Please sign in to leave a comment.