知識庫

Date “1899/12/30” in Output File After Changing Data Type From “String” to “Date” in Tableau Prep with non-English OS

發佈時間 : 06 Jan 2023
上次修改日期 : 06 Jan 2023

問題

The output file shows 1899/12/30 only upon changing from String to Date and when connecting to a published data source on Tableau Server.

Note: the Tableau Server OS is Non-English(e.g. Japanese, Korean, Chinese).  There is no issue when using Tableau Server with English OS.

For example, the preview data in Tableau Prep is correct.
User-added image

However, after outputting the data, all the dates are shown as 1899/12/30.

環境

  • Tableau Prep Builder
  • Tableau Server Data Source
  • Windows CJK OS
  • Hyper

解決方法

Please consider the below workarounds:

Option 1:
Duplicate the String field and change the Data Type from String to Date of the duplicated field then use it.
For example, duplicate [YMD] to [YMD-Copy] and change the data type for [YMD-Copy]. 
Option 2:
Change the field name of the String field at the Cleaning step. 
For example, from [YMD] to [YMD-1]
Option 3:
Do not change the Data Type and output the field as a String in Tableau Prep.
 Import the data to Tableau Desktop and change the data type.

原因

This issue is currently being investigated under Known Issue ID 1465501. 
這篇文章是否解決了問題？    
PRINT THIS PAGE
Trending Articles
Results 1-3 of 948
附件


所有支援服務

支援（按產品分類）
工具與下載
資訊
協助