Replace Data Sources - Tableau

link管理

链接快照平台

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

相关文章推荐

阳刚的火腿肠 · 如何在stata中将字符型数据库 | ...· 1 月前 ·

细心的绿豆 · destring — ...· 1 月前 ·

坏坏的雪糕 · Python获取JSON数据详解 - 搬砖的码农· 3 周前 ·

大鼻子的大葱 · 子查询调优_云数据库 GaussDB_华为云· 5 月前 ·

玩手机的西红柿 · 《依赖于框架的打包的应用程序的 ...· 7 月前 ·

乖乖的小熊猫 · python modbus RTU-CSDN博客· 1 年前 ·

不爱学习的红薯 · 卡拉彼丘超弦测试疑难问题汇总_mjj游戏站· 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-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">Replace Data Sources</h2><div class="caption article__tags content-only-hidden quick-help-hidden"><span class="article__tags--applies-to"> </span><br/><span class="article__tags--role"> </span></div><div id="content-body">&#13; <p class="note"><b>Note:</b> Replacing a data source isn’t supported by Tableau Cloud or Tableau Server. </p>&#13; <p>Users can update a workbook&#13; or sheet with a different data source. Replacing a data source doesn’t merge or edit the data sources. It redirects fields used in the worksheet to map to corresponding fields in the new data source. Any fields that the user creates in the <i>original</i> data source are copied over to the new data source. Fields that aren’t included in the original data source must be manually copied and pasted to the <i>new</i> data source before replacing the old one. When you replace a data source, the folder structures aren't copied over. </p>&#13; <p>The two data sources don’t have to be identical, any&#13; differences between the data sources will affect the sheets in the workbook and the fields in the view. Any fields, groups, sets, and calculated fields that&#13; don’t exist in the new data source (or have a different name) are removed from the Data pane. For more information about how to replace field references to fix invalid fields, see <a href="howto_connect.htm" class="MCXref xref">Edit Data Sources</a>. </p>&#13; <h3 is="heading-item" :level="3" id="replace-a-data-source">Replace a Data Source</h3>&#13; <p>Complete the following steps to replace a data source. </p>&#13; <li value="1">Open a workbook that connects to the <i>original</i> data source. </li>&#13; <li value="2">Select <span class="uicontrol">Data</span> &gt; <span class="uicontrol">New Data Source</span> and then connect to the <i>new</i> data&#13; source.</li>&#13; <li value="3">On the Data Source page, drag a table to the canvas to set up the data source (if this isn’t automatically done for you).</li>&#13; <li value="4">Go to the sheet tab and select <span class="uicontrol">Data</span> &gt; <span class="uicontrol">Replace&#13; Data Source</span>.&#13; <p class="note"><b>Note:</b> You must have at least one field in the view to make the <span class="uicontrol">Replace Data Source</span> option available.</p><p><img src="Img/connect_basic_replace1.png" style="text-align: center;" alt=""/></p></li>&#13; <li value="5">In the Replace Data Source dialog box, select the <span class="uicontrol">Current</span> data source and the <span class="uicontrol">Replacement</span> data source.</li>&#13; <li value="6">(optional) Under the <b>Current</b> field, select the checkbox to replace the current worksheet only. </li>&#13; <li value="7">When finished, select <span class="uicontrol">OK</span>. </li>&#13; <p>All worksheets, dashboards, and stories that used the <i>original</i> data source are updated to use the <i>new</i> data source. You can click <span class="uicontrol">Undo</span> on&#13; the toolbar to revert the change and return to the original data source.</p>&#13; <p class="note"><b>Note:</b> You can only replace one data source with another data source when both data sources are relational data sources, or when both data sources are cube (multidimensional) data sources. In Tableau, cube data sources are supported for Windows only. </p>&#13; <h3 is="heading-item" :level="3" id="replace-the-data-source-for-a-single-sheet">Replace the Data Source for a Single Sheet</h3>&#13; <p>If you wish to replace the data source for a single sheet, select the checkbox for <span class="uicontrol">Replace current worksheet only</span>. </p>&#13;