Data Types - Tableau

link之家

链接快照平台

输入网页链接，自动生成快照
标签化管理网页链接

相关文章推荐

知识渊博的番茄 · 自訂和調整連線 - Tableau· 2 月前 ·

直爽的黄花菜 · Excel - Tableau· 1 月前 ·

有爱心的回锅肉 · Microsoft SQL Server ...· 11 小时前 ·

千杯不醉的回锅肉 · 网络热门ChatGPT量化交易研究报告盘点（ ...· 1 年前 ·

爱旅游的冰棍 · python异步爬虫获取返回值 ...· 2 年前 ·

调皮的杯子 · vue+electron中的app.vue中 ...· 2 年前 ·

任性的便当 · ora-00030:User ...· 2 年前 ·

</noscript><div id="app" class="wrapper"><header id="tableau-help-article-header" class="container--full-width quick-help-header"><div class="container--centered"><div class="header__mobile-menu quick-help-hidden"><menu-tree-toggle/></div><div class="header__logo quick-help-hidden"><a id="tableau-logo" href="https://www.tableau.com/en-us/"><img src="./Resources/tableau-logo.png" class="header__logo__img" alt="Tableau"/></a></div><div class="header__search"><search-header-help placeholder="Search"/></div></div></header><div class="container--navigation-top quick-help-hidden content-only-hidden"><div id="help-subheader" class="subheader print-hidden"><div class="container--centered"><h1 class="heading--subheader">Tableau Desktop and Web Authoring Help</h1></div></div><div class="container--top-links"><div class="container--centered container--breadcrumbs"><div><breadcrumb-links-help/></div></div><div id="help-container-menu-headings" class="container--menu-headings"><nav class="nav-medium-screen"><menu-heading-links-static-help menu-title="In this article" :disabled="false" :headings="pageHeadings"/></nav></div></div></div><div class="section--main container--full-width"><div class="container--centered"><nav class="nav-side nav-side--left" role="navigation"><menu-tree-help menu-title="Contents"/></nav><article role="main"><h2 class="topic--title" id="topic-title" tabindex="-1">Data Types</h2><div class="caption article__tags content-only-hidden quick-help-hidden"><span class="article__tags--applies-to">Applies to: Tableau Desktop</span><br/><span class="article__tags--role"> </span></div><div id="content-body">&#13; <p>All fields in a data source have a data type. The data type reflects the kind of information stored in that field, for example integers (410), dates (1/23/2025) and strings ("Belgium"). The data type of a field is identified in the <b>Data</b> pane by one of the icons shown below.</p>&#13; </p><h2 is="heading-item" :level="2" id="data-type-icons-in-tableau">Data type icons in Tableau</h2>&#13; <p>You can change the data type for a field either on the <b>Data Source</b> page or in the <b>Data</b> pane. </p>&#13; <h2 is="heading-item" :level="2" id="change-the-data-type-for-a-field-in-the-data-source-page">Change the data type for a field in the Data Source page</h2>&#13; <p>Sometimes Tableau incorrectly interprets the data type of a field. For example, Tableau might interpret a field that contains dates as an integer data type, rather than a date data type. </p>&#13; <p>You can change the data type for a field that was part of the original data source (as opposed to a calculated field created in Tableau) on the <b>Data Source</b> page. </p>&#13; <p>Click the data type icon for the field (as shown in the table above).</p>&#13; <p>Choose a new data type from the drop-down list:</p>&#13; <p class="note"><b>Tip</b>: Be sure to change data types before you create an extract. Otherwise, your data may not be accurate. For example, if a floating-point field in the original data source is interpreted as an integer by Tableau, and you create your extract before you change the field's data type, the resulting floating-point field in Tableau will have some of its precision truncated. </p>&#13; <p>For information on changing data types on the <span class="uicontrol">Data Source</span> page, see <a href="environment_datasource_page.htm" class="MCXref xref">Data Source Page</a>.</p>&#13; <h2 is="heading-item" :level="2" id="change-the-data-type-for-a-field-in-the-data-pane">Change the data type for a field in the Data pane</h2>&#13; <p>To change the data type of a field in the <span class="uicontrol">Data</span> pane, click the icon to the left of the field name, and then choose a new data type from the drop-down list.</p>&#13; <h2 is="heading-item" :level="2" id="change-the-data-type-for-a-field-in-the-view">Change the data type for a field in the view</h2>&#13; <p>To change a field's data type in a view, right-click (control-click on a Mac) the field in the <span class="uicontrol">Data</span> pane, choose <span class="uicontrol">Change Data Type</span>, and then select the appropriate data type from the drop-down list.</p>&#13; <p class="note"><b>Note:</b> Sometimes the data in your database is more precise then&#13; Tableau can model. When you add these values to the view, a precision&#13; warning appears in the right corner of the status bar. See <a href="environment_workspace.htm#StatusBar" class="MCXref xref">Status Bar Information</a>.</p>&#13; <h2 class="sectiontitle" is="heading-item" :level="2" id="mixed-data-types-in-data-from-files">Mixed data types in data from files</h2>&#13; columns in a Microsoft Excel, Microsoft Access, or CSV (comma-separated value) file contain&#13; values that are all of the same data type (Booleans, dates, numbers, or text). When you connect&#13; to the file, Tableau creates a field in the appropriate area of&#13; the <span class="uicontrol">Data </span>pane for each column. Dates and text values are dimensions, and numbers are measures.</p>&#13; <p>However, files that you connect to might include columns that have a mixture&#13; of data types, such as numbers and text, or numbers and dates. When&#13; you connect to the file, the mixed-value column is mapped to a field&#13; with a single data type in Tableau. Therefore, a column that contains&#13; numbers and dates might be mapped as a number data type (making it a measure) or it might be mapped&#13; as a date data type (in which case Tableau treats it as a dimension.)</p>&#13; <p>Tableau determines how to map mixed-value columns to data types by the data types&#13; of the first 10,000 rows in an Excel data source, and the first 1,024 rows in a CSV data source. For example, if most of&#13; the first 10,000 rows are text values, the entire column is mapped&#13; to use the text data type.</p>&#13; <p class="note"><b>Note:</b> Empty cells also create mixed-value columns&#13; because their formatting is different from text, dates, or numbers.</p>&#13; <p>When Tableau determines a data type for each field, if the values in a field don't match that data type, Tableau handles the field in one of several different ways, depending on the data type. For example, sometimes Tableau populates those fields with Null values, as shown in the following table: </p>&#13; <td class="TableStyle-Basic-Border-BodyE-Column1-Body1">Dates</td>&#13; <td class="TableStyle-Basic-Border-BodyD-Column1-Body1">Text is treated as Null. A number is treated as the day in numeric order from 1/1/1900.</td>&#13; <td class="TableStyle-Basic-Border-BodyE-Column1-Body1">Numbers</td>&#13; <td class="TableStyle-Basic-Border-BodyD-Column1-Body1">Text is treated as Null. A date is treated as the number of days since 1/1/1900.</td>&#13; <td class="TableStyle-Basic-Border-BodyB-Column1-Body1">Boolean</td>&#13; <td class="TableStyle-Basic-Border-BodyA-Column1-Body1">Text, dates, and numbers are treated as Null.</td>&#13; <p>If using fields that are based on mixed-value&#13; columns introduces difficulties when analyzing your data, you can do one of the following:</p>&#13; <p>Format empty cells in your underlying data source so that they&#13; match the data type of the column.</p>&#13;