Data Types - Tableau

相关文章推荐

谦逊的沙滩裤 · 提高跨数据库联接的性能 - Tableau· 1 周前 ·

留胡子的茶壶 · MySQL 连接器 - Tableau - ...· 1 周前 ·

知识渊博的柚子 · 2023中国南通江海国际文化旅游节新闻发布会 ...· 6 月前 ·

风流的豌豆 · 医患矛盾如何破，看看镇江的“熟人医疗”-新华网· 11 月前 ·

温暖的凉茶 · 【原神/同人图】某网站高质量同人图19_哔哩 ...· 1 年前 ·

侠义非凡的椰子 · 求photoshop7.0 发百度云盘_百度知道· 1 年前 ·

腼腆的水龙头 · 丁磊卖车，全靠有钱人_36氪· 1 年前 ·

</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-gb/"><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; <div id="mc-main-content"><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><p/><h2 is="heading-item" :level="2" id="data-type-icons-in-tableau">Data type icons in Tableau</h2><table style="mc-table-style: url('Resources/TableStyles/Basic-Border.css');border-left-style: solid;border-left-width: 1px;border-left-color: #000000;border-right-style: solid;border-right-width: 1px;border-right-color: #000000;border-top-style: solid;border-top-width: 1px;border-top-color: #000000;border-bottom-style: solid;border-bottom-width: 1px;border-bottom-color: #000000;margin-left: 0;margin-right: auto;" class="TableStyle-Basic-Border" cellspacing="0"><colgroup><col class="TableStyle-Basic-Border-Column-Column1" style="width: auto;"/><col class="TableStyle-Basic-Border-Column-Column1" style="width: auto;"/></colgroup><thead><tr class="TableStyle-Basic-Border-Head-Header1"><th class="TableStyle-Basic-Border-HeadE-Column1-Header1">Icon</th><th class="TableStyle-Basic-Border-HeadD-Column1-Header1">Data type</th></tr></thead><tbody><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyE-Column1-Body1"><img src="Img/symbol_text.png" style="text-align: center;" alt=""/></td><td class="TableStyle-Basic-Border-BodyD-Column1-Body1">Text (string) values</td></tr><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyE-Column1-Body1"><img src="Img/symbol_date.png" style="text-align: center;" alt=""/></td><td class="TableStyle-Basic-Border-BodyD-Column1-Body1">Date values</td></tr><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyE-Column1-Body1"><img src="Img/symbol_datetime.png" alt=""/></td><td class="TableStyle-Basic-Border-BodyD-Column1-Body1">Date &amp; Time values</td></tr><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyE-Column1-Body1"><img src="Img/symbol_number.png" style="text-align: center;" alt=""/></td><td class="TableStyle-Basic-Border-BodyD-Column1-Body1">Numerical values</td></tr><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyE-Column1-Body1"><img src="Img/symbol_bool.png" style="text-align: center;" alt=""/></td><td class="TableStyle-Basic-Border-BodyD-Column1-Body1">Boolean operators (relational only)</td></tr><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyE-Column1-Body1"><img src="Img/geoicon.png" style="text-align: center;" alt=""/></td><td class="TableStyle-Basic-Border-BodyD-Column1-Body1">Geographic values (used with maps)</td></tr><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyE-Column1-Body1"><img src="Img/symbol_imagerole.png" alt=""/></td><td class="TableStyle-Basic-Border-BodyD-Column1-Body1">Image role (used with image link URLs)</td></tr><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyB-Column1-Body1"><img src="Img/Schema_Viewer_Group_Cluster_Discrete_25x20.png" style="width: 25;height: 20;" alt=""/></td><td class="TableStyle-Basic-Border-BodyA-Column1-Body1">Cluster Group (used with <a href="clustering.htm" target="_blank" class="MCXref xref">Find Clusters in Data<span class="sr-only">(Link opens in a new window)</span></a>)</td></tr></tbody></table><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><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><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><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><ol><li value="1"><p>Click the data type icon for the field (as shown in the table above).</p></li><li value="2"><p>Choose a new data type from the drop-down list:</p><p><img src="Img/datatype0.png" alt=""/></p></li></ol><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><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><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><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><p><img src="Img/datatype2.png" alt=""/></p><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><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><p><img src="Img/datatype1.png" style="text-align: center;" alt=""/></p><p class="note"><b>Note:</b> Sometimes the data in your database is more precise then Tableau can model. When you add these values to the view, a precision 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><h2 class="sectiontitle" is="heading-item" :level="2" id="mixed-data-types-in-data-from-files">Mixed data types in data from files</h2><p>Most columns in a Microsoft Excel, Microsoft Access, or CSV (comma-separated value) file contain values that are all of the same data type (Boolean operators, dates, numbers, or text). When you connect to the file, Tableau creates a field in the appropriate area of the <span class="uicontrol">Data </span>pane for each column. Dates and text values are dimensions, and numbers are measures.</p><p>However, files that you connect to might include columns that have a mixture of data types, such as numbers and text, or numbers and dates. When you connect to the file, the mixed-value column is mapped to a field with a single data type in Tableau. Therefore, a column that contains numbers and dates might be mapped as a number data type (making it a measure) or it might be mapped as a date data type (in which case Tableau treats it as a dimension.)</p><p>Tableau determines how to map mixed-value columns to data types by the data types 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 the first 10,000 rows are text values, the entire column is mapped to use the text data type.</p><p class="note"><b>Note:</b> Empty cells also create mixed-value columns because their formatting is different from text, dates, or numbers.</p><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><table style="mc-table-style: url('Resources/TableStyles/Basic-Border.css');margin-left: 0;margin-right: auto;" class="TableStyle-Basic-Border" cellspacing="0"><colgroup><col class="TableStyle-Basic-Border-Column-Column1"/><col class="TableStyle-Basic-Border-Column-Column1"/></colgroup><thead><tr class="TableStyle-Basic-Border-Head-Header1"><th class="TableStyle-Basic-Border-HeadE-Column1-Header1">Mapped data type</th><th class="TableStyle-Basic-Border-HeadD-Column1-Header1">Treatment of other data types in the field.</th></tr></thead><tbody><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyE-Column1-Body1">Text</td><td class="TableStyle-Basic-Border-BodyD-Column1-Body1">Dates and numbers are treated as text. Nulls are not created.</td></tr><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyE-Column1-Body1">Dates</td><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></tr><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyE-Column1-Body1">Numbers</td><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></tr><tr class="TableStyle-Basic-Border-Body-Body1"><td class="TableStyle-Basic-Border-BodyB-Column1-Body1">Boolean</td><td class="TableStyle-Basic-Border-BodyA-Column1-Body1">Text, dates, and numbers are treated as Null.</td></tr></tbody></table><p>If using fields that are based on mixed-value columns introduces difficulties when analysing your data, you can do one of the following:</p><ul><li><p>Format empty cells in your underlying data source so that they match the data type of the column.</p></li><li><p>Create a new column that does not contain the mixed values.</p></li></ul></div></div><div class="article__footer--back-to-top text--centered print-hidden quick-help-hidden"><a href="#" class="text--caps" onclick="setFocus()"><span class="icon--med icon--arrow-up"/> Back to top</a></div><feedback-form :disabled="false" class="print-hidden content-only-hidden" helpful-question="Did this article solve your issue?" helpful-yes="Yes" helpful-no="No" comment-question="We value your feedback. Add comments here." submit-option="Send" cancel-option="Cancel" loading-text="Sending..."><span slot="submittedMessage">Thanks for your feedback!</span></feedback-form><d-s-c-feedback-form :disabled="false" class="print-hidden content-only-hidden quick-help-hidden" feedback-question="Did this article solve your issue?" feedback-subtitle="Let us know so we can improve!" helpful-yes="Yes" helpful-no="No" error-message="Please tick at least 1 box." thanks-positive-feedback="Thanks for the feedback! What made this article helpful?" thanks-negative-feedback="We’re sorry to hear that. How can we improve this article?" feedback-yes-accurate="Contains accurate information" feedback-yes-comprehensive="Includes all of the information I need" feedback-yes-clear="Easy to understand with clear explanations and visuals" feedback-no-accurate="Contains inaccurate or outdated information" feedback-no-comprehensive="Missing important information" feedback-no-clear="Confusing or difficult to understand" feedback-no-descriptive="The article is OK, but I don’t like how the product described works" feedback-something-else=" Something else" additional-feedback="Would you like to share any additional feedback?" submit-answers="Submit"><span slot="successfullySubmitted">Your feedback has been successfully submitted. Thank you!</span></d-s-c-feedback-form></article><nav class="nav-side nav-side--right"><menu-heading-links-scrollable-help menu-title="In this article" :disabled="false" :headings="pageHeadings"/></nav></div></div><feedback-button-floating tooltip="Send feedback" :disabled="false"/><footer class="container--full-width"><div class="container--centered"><div class="footer__links text--caps"><ul><li><a href="https://www.tableau.com/en-gb/legal" class="">Legal</a></li><li><a id="privacyLink" class="">Privacy</a></li><li><a href="#" data-ignore-geolocation="true" class="optanon-toggle-display">Cookie Preferences</a></li></ul></div><div class="footer__copyright text--caps"><copyright-notice year-start="2003" notice-text="Salesforce, Inc."/></div></div></footer></div> </body>