Replace Data Sources - Tableau

link之家

链接快照平台

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

相关文章推荐

活泼的柚子 · 選擇預測模型 - Tableau· 3 月前 ·

无邪的橙子 · 顾凯俐_百度百科· 1 年前 ·

非常酷的双杠 · 星梦美少女吧的精品贴_星梦美少女吧_百度贴吧· 3 年前 ·

沉着的汉堡包 · LOFTER官方新版本-安卓iOS版下载-应 ...· 3 年前 ·

跑龙套的青蛙 · 全国教育科学规划领导小组办公室· 3 年前 ·

阳刚的消防车 · 母鸡山鸡mp3下载 - 百度· 3 年前 ·

</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;