Data Source Page - Tableau

相关文章推荐

灰常酷的蘑菇 · 客户买了小鹅通课程找不到了怎么办？· 9 月前 ·

有胆有识的便当 · 城市收藏夹｜慕尼黑的二月 - 少数派· 1 年前 ·

曾深爱过的苦咖啡 · 北京师范大学党委学生工作部· 1 年前 ·

骑白马的包子 · WPF 在 MVVM ...· 1 年前 ·

健身的铁链 · 《花少2》展示过最真实的郑爽|许晴|杨洋|井 ...· 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__back-button"><back-button title="Go back"/></div><div class="header__mobile-menu quick-help-hidden"><menu-tree-toggle/></div><div class="header__logo quick-help-hidden"><a 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 class="header__home-button"><home-button title="Go home"/></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"><h4 class="heading--subheader">Tableau Desktop and Web Authoring Help</h4></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"><h1 id="contentH1"/><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 xmlns:madcap="http://www.madcapsoftware.com/Schemas/MadCap.xsd" id="content-body">&#13; <p>Before or during your analysis, you may want to make changes to the Tableau data source. You can do that on the data source page. Tableau takes you to the data source page after you establish the initial connection to your data. You can also access the data source page by clicking the <span class="uicontrol">Data Source</span> tab from any location in the workbook.</p>&#13; <p class="note"><b>Watch a video</b>: To see related concepts on connecting to data and using the Data pane, watch <a href="https://www.tableau.com/learn/tutorials/on-demand/getting-started-data" target="_blank">Getting Started with Data<span class="sr-only">(Link opens in a new window)</span></a>, a 6-minute free training video. Use your <a href="http://www.tableau.com/" target="_blank">tableau.com<span class="sr-only">(Link opens in a new window)</span></a> account to sign in.</p>&#13; <p>Although the look of the page and the options available vary depending on the type of data that you are connected to, the data source page generally consists of four main areas: left pane, canvas, data grid, and metadata grid.</p>&#13; </conditionaltext><a href="#Canvas" class="MCXref xref" xrefformat="{paratext}">Canvas</a>: logical layer - The canvas opens with the logical layer, where you can create relationships between logical tables. </p>&#13; </conditionaltext><a href="#Canvas" class="MCXref xref" xrefformat="{paratext}">Canvas</a>: physical layer - Double-click a table in the logical layer to go to the physical layer of the canvas, where you can add joins and unions between tables.</p>&#13; </conditionaltext><a href="#Data" class="MCXref xref" xrefformat="{paratext}">Data grid</a> - Displays first 1,000 rows of the data contained in the Tableau data source.</p>&#13; </conditionaltext><a href="#Metadata" class="MCXref xref" xrefformat="{paratext}">Metadata grid</a> - Displays the fields in your data source as rows.</p>&#13; <p style="text-align: right"><a href="#top">Back to top</a>&#13; <h2 is="heading-item" :level="2" id="left-pane"><a name="Left"/>Left pane</h2>&#13; <p>The left pane of the data source page displays details about your data—the data that Tableau Desktop is connected to. </p>&#13; <p>For file-based data, the left pane might display the file name and the worksheets in the file. </p>&#13; <p>For relational-based data, the left pane might display the server, the database or schema, and the tables in the database. </p>&#13; <p>You can also use the left pane to add more connections to the data source to create cross-database joins.</p>&#13; <p>The left pane does not display for cube (multidimensional) data.</p>&#13; <h2 is="heading-item" :level="2" id="canvas"><a name="Canvas"/>Canvas</h2>&#13; <p>When connected to most relational and file-based data, you can drag one or more tables to the canvas area to set up your Tableau data source. The canvas now has two layers: a logical layer and a physical layer. The default view shows the logical layer, which uses relationships between logical tables. To go to the physical layer, double-click a logical table in the logical view and create joins and unions between tables in the physical layer. For more information, see Tableau Data Model.</p>&#13; <p>When connected to cube data, the top of the data source page displays the available catalog or queries and cubes to select from to set up your Tableau data source.</p>&#13; <p class="note"><b>Note</b>: Depending on the type of data you are connected to, you can refresh your data when that data has changed using a number of options. For example if connected to a data extract, you can refresh a selected extract using the <span class="uicontrol">Refresh</span> button <img src="Img/refresh_extract_datapane.png" alt=""/> that appears next to the Connection area in the left side of the pane. For more information about refresh options see <a href="refreshing_data.htm" target="_blank" class="MCXref xref" xrefformat="{paratext}">Refresh Data Sources<span class="sr-only">(Link opens in a new window)</span></a>. For more information about refreshing data extracts, see <a href="extracting_refresh.htm" target="_blank" class="MCXref xref" xrefformat="{paratext}">Refresh Extracts<span class="sr-only">(Link opens in a new window)</span></a>.</p>&#13; <h3 is="heading-item" :level="3" id="refreshing-your-data-source">Refreshing your data source</h3>&#13; <p>Depending on the type of data you are connected to you can refresh your data when that data has changed using a number of options. For example if connected to a data extract, </p>&#13; <h2 is="heading-item" :level="2" id="data-grid"><a name="Data"/>Data grid</h2>&#13; <p>Use the data grid to review the fields and the first 1,000 rows of the data contained in the Tableau data source. You can also use the data grid to make general modifications to the Tableau data source like sorting or hiding fields; renaming fields or resetting field names; creating calculations; changing the column or row sort; or adding aliases. For the Web Data Connector, file- and relational-based data sources in Extract mode, you can see extract data in the grid, including extract only calculations.</p>&#13; <p>When you're in the logical layer, you see the data for the selected table.</p>&#13; <p>In the physical layer, you see the merged data based on the joins and unions.</p>&#13; <p>To select multiple fields in the grid, click a column, and then drag the mouse to select more columns. </p>&#13; <p>To select all fields, click the area in the upper-left corner of the grid like in the example, below.</p>&#13;