{"id":4090,"date":"2020-07-21T19:27:22","date_gmt":"2020-07-21T13:57:22","guid":{"rendered":"https:\/\/www.h2kinfosys.com\/blog\/?p=4090"},"modified":"2024-10-17T16:19:21","modified_gmt":"2024-10-17T10:49:21","slug":"tableau-data-connection-with-data-sources","status":"publish","type":"post","link":"https:\/\/www.h2kinfosys.com\/blog\/tableau-data-connection-with-data-sources\/","title":{"rendered":"Tableau Data Connection with Data Sources"},"content":{"rendered":"\n<p>Tableau can connect with a wide variety of data sources, making it a versatile tool for data analysis. These include Excel files, text files, PDF files, and databases through ODBC connectors. Additionally, Tableau can link with websites, servers, and cloud-based data warehouses, allowing users to bring together diverse datasets for a holistic view of their data. With <strong><a href=\"https:\/\/www.h2kinfosys.com\/courses\/tableau-online-training-course-details\/\">Tableau<\/a> Data Connection<\/strong> capabilities, users can seamlessly integrate data from multiple sources, enabling real-time analysis, collaboration, and interactive dashboards to enhance decision-making across industries.<\/p>\n\n\n\n<p><strong>Following types of data sources can be connected to the Tableau:<\/strong><\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>File System:<\/strong> For example, Microsoft Excel, CSV, etc.<\/li>\n\n\n\n<li><strong>Cloud System:<\/strong> For example, Google Big Query, Microsoft Azure, etc.<\/li>\n\n\n\n<li><strong>Relational System:<\/strong> For example, Microsoft SQL Server, DB2, Oracle, etc.<\/li>\n\n\n\n<li><strong>Other Sources:<\/strong> For example, ODBC.<\/li>\n<\/ul>\n\n\n\n<p>The below picture shows the various types of data sources available in Tableau:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/ZR0pc3XmsDg-DM0ejTOabKZSW0FBcGRF_pyKSOtwXmr62k80HYZHBJYPpGPajhoPyfiHlRI5c2uhatqlCN8yefVj0xLackt6ZikO-xyfxckoKY17c7nz7pME60qxbYwJcWIID8RUbwR3OT8jhw\" alt=\"Data Connection with Data Sources\" title=\"\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to make a connection with the Text File?<\/strong><\/h2>\n\n\n\n<p>Tableau can connect to the following text files:&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>.csv<\/li>\n\n\n\n<li>.tsv<\/li>\n\n\n\n<li>.txt<\/li>\n\n\n\n<li>.tab<\/li>\n<\/ul>\n\n\n\n<p><strong>Step 1: <\/strong>Open the <a href=\"https:\/\/www.h2kinfosys.com\/blog\/what-is-tableau\/\">Tableau Desktop<\/a>.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Click on the <strong>Text File<\/strong> option available below the <strong>Connect.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/frn264P7_Ks8STkVsnCYKwRkKdDr4qPLe7B1r9GJjN2x04cpK_EQkO12sSyq4x4p0wG80WeD7clpACWnXRrCiKzmud1spV1zOIsBpaEYitbnm2r8GtLU5ogM3abgu6AKJHUIR5KlcjFe4KyjEg\" alt=\"Tableau Data Connection with Text File\" title=\"\"><\/figure>\n\n\n\n<p><strong>Step 3: <\/strong>Select the file to connect and click on the Open button.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/0meoPBrR8V7YK47DnvBvcyPxEyeU4jnsKfPJhIfZCjexoH4BKJAGVAkRsEvRyfTc4sjDVYPv7zHhWptq02l8Jb4Z-ai4XQOW9uhn7E0T_NQiDb_t4Onjq3EEcgGx6LSalk5g5yvY4zcYcMEYyw\" alt=\"Tableau Data Connection with Text File\" title=\"\"><\/figure>\n\n\n\n<p><strong>Step 4: <\/strong>Now, you will see the CSV file on the data source&#8217;s left side.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/pOB_W3js098CY2I7FSwCAXj2dBHTQb_DvMYU9whEvNeI_MbhnhqH8x-3zWXPj__By2nGCPKRqwdl3GS7uqKKbUb_2nVi7_y2tWJ48EgqKPBbuJP7kOAOIiUwXAZS3yVb_c1dZb1XRCTqjc81qQ\" alt=\"Tableau Data Connection with Text File\" title=\"\"><\/figure>\n\n\n\n<p>The worksheet will look like this:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/szK-gDv4wfUAc7A3yXqTZzctUBVmlQxin1Z8xkv0VDZuyYco1uBcfC98zCGrC13YczkzBRo7dj0lWsruxr9sGbOdiy8z-vYgQpPBXUJRbyMmgsfe74fKYqyrfingLUc0b4rcpZa1zkEPy9nlPQ\" alt=\"Tableau Data Connection with Text File\" title=\"\"><\/figure>\n\n\n\n<p>The below image shows the list of currently connected data sources:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/wIRd9AzDyL2ZDrntrjxsIXTdemaF7N6dOsCzwIBK93yOHsTKGYTAcoSLgSKXAfgMm4xnCtZPUpDomEb6I8B-Aclqyh5v0DskIIz4f_MPj0sUg1pnw5QX9M2IQsn2mqbeC-xsjqNK2IgM-ulrew\" alt=\"Tableau Data Connection with Text File\" title=\"\"><\/figure>\n\n\n\n<p>We have only one data source connected at this time. Columns with string data can be placed under the Dimensions section, and columns with numeric data can be placed under the Measures section.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to make a connection with the Excel File?<\/strong><\/h2>\n\n\n\n<p><strong>Step 1: <\/strong>Open the Tableau Desktop.<strong>Step 2: <\/strong>Click on the <strong><a href=\"https:\/\/www.h2kinfosys.com\/courses\/microsoft-office\/\">Microsoft Excel<\/a><\/strong> option available below the <strong>Connect.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/YFFqVFj9GJQNjVpRcFW3XAXHLy-7qilHfrbXtuH8S11H5Jmb4EV_OlHlQxeAwhV6y7rcaKiRSujcr1oSUPIflqRX3yi9hIwBaIeURTvYtCo9YvXY5gM_kER2QZ3Xj4TH9LrMqA09Yn-BzYKD1g\" alt=\"Tableau Data Connection with Microsoft Excel\" title=\"\"><\/figure>\n\n\n\n<p><strong>Step 3: <\/strong>Select the file to connect and click on the Open button.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/xo33TENvdPnbB03tp5a_afHdVc6J_2Fw3YLspBq0L0rA6_MKbktrJqhbV3rWEWeL6c2VKbjeJoosqfqiei6TOwD4UfNhQDz6dO5Pt-ytEF3KDAr7oYFDx-oX7y93hWGpYkdH4P7U3VzNdfDsqg\" alt=\"Tableau Data Connection with Microsoft Excel\" title=\"\"><\/figure>\n\n\n\n<p><strong>Step 4: <\/strong>Now, you will see the XLS file on the left side of the data source.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/whl_orytth4rHdnA8R9ZUCbK6m2zDie_-6nzto9oIckFubXMMA-q1aTxJc96YK8yDk1xCSyvP10ZQPo6aeiAgBv5-P-7i1HWcfQ85f50yOG0WNAgBMA5-9VD8iW5Pio8J3zeT7RW6gDm06au0Q\" alt=\"Tableau Data Connection with Microsoft Excel\" title=\"\"><\/figure>\n\n\n\n<p><strong>Step 5: <\/strong>More than one sheet can be dragged from the sheets tab.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/B27waJbBPQIYEvviYIiGq6kA4OuGBqzjcEcR4uADrPPYDhtrIYmRkf_Oh4MQ8EgmyaijW53QhOCmCThNiT17v4ESrXd1sJL049q0vP8GTPDI8ksYjCz0PHjnEHFzNAOfMK07UnNLL4wdIkUE8g\" alt=\"Tableau Data Connection with Microsoft Excel\" title=\"\"><\/figure>\n\n\n\n<p>The worksheet looks like:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/L0NqxEZlsYX9c6UsT6MQhorZcgOY9zaF6qLrVJtd8bhD9Hi-y5dmKel0WyDiHT4TSfnxXPxUOStvN1AnJ57JjStQ7bbhquNsytgRELlU4LyypPeM7vlNxx5h1cik9czPQObonjBAXJrc9udmtw\" alt=\"Tableau Data Connection with Microsoft Excel\" title=\"\"><\/figure>\n\n\n\n<p>Similarly, the below image shows the list of currently connected data sources where columns with string data can be placed under the Dimensions section and columns with numeric data can be placed under Measures section:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/WkjXDulTrRg2tdirXG2Q4Cwu02dLg-Wv-yx2l1WNsaPQnEvM_KvSX8Ett0mwhZyABPhLlfGt7yBONkhSMYFEVO8UtnmgSFeNzXD1OUwvCjCS0yqANH_M9Si6_7wbtV8Z2DvVKLI1GwN3WVywmA\" alt=\"Tableau Data Connection with Microsoft Excel\" title=\"\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to make a connection with the Database?<\/strong><\/h2>\n\n\n\n<p><strong>Step 1: <\/strong>Open the Tableau Desktop.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Click on the required database, such as <strong><a href=\"https:\/\/www.h2kinfosys.com\/courses\/sql-online-training-course\/\">MySQL<\/a> <\/strong>option available below the <strong>Connect.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/5v4Idktq0Xr6JYZ2SYMthvluYeT-uO1eG9rxsRhPLI37_bTl3UvQ0Lu5GlU-zizP0I-RtRj0e-aOHggFKbWAR2p1ACTgHuOI5ZQtzDJtWfcEtmsO_5f--pvt_ViMrKzSXGgypBKHQC0w8rruMA\" alt=\"https:\/\/www.guru99.com\/images\/tableau\/060818_0511_TableauConn8.jpg\" title=\"\"><\/figure>\n\n\n\n<p><strong>Step 3: <\/strong>A dialog box will appear. Enter the name of the server and port. The default value of the port is 3306. Enter the required fields Username and Password and click on the Sign-in button. If you want to connect to the SSL server, click on the <strong>Require SSL<\/strong> checkbox. If you want to specify a SQL command that should run at the beginning of every connection, click on <strong>Initial SQL<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/iWsWAT6XnjgeYmMR9sR_0xnYyVyONTvOgC4CNZani90CxcL86bazyotAxs1sffKo2Dct9Snh3q4ek9HNxAqY6aGamS_H8Z0sEt7p5muoHnEcIA8LHaqJMPopCa_FTkablh2UvBm2LgxCcDVyYA\" alt=\"https:\/\/www.edureka.co\/community\/?qa=blob&amp;qa_blobid=10425111308816553892\" title=\"\"><\/figure>\n\n\n\n<p><strong>Step 4: <\/strong>Select the required database.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/-cJHwOTpBnkUGJD-4m3KO9A6-Uuzy6muF2nuR-jyEsCyk8zJqBzTGZe3SdPrBZb6HUqKwyIi915l5LWaesHrKld_oglbs4VSL4eEoZnwRjSUaqmQAOz-mX8ChhMIIUBEZGghcvaDOn9EtlyvMg\" alt=\"\" title=\"\"><\/figure>\n\n\n\n<p>Multiple tables can also be joined by creating a relationship between them.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to make a connection with the Website?<\/strong><\/h2>\n\n\n\n<p><strong>Step 1: <\/strong>Open the Tableau Desktop.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Click on the option <strong><a href=\"https:\/\/tableau.github.io\/webdataconnector\/\" rel=\"nofollow noopener\" target=\"_blank\">Web Data Connector<\/a><\/strong> available under option <strong>More.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/W5_P-pzzGWAxxoEv6Yn3aM2RWxfuVKaLchU7kWmRVD5ImnME0nHliY29tTs2HYz5zpfrwhCppRp5i56cYgaVcRyHSloO8sTr-l-p6Ax_2SSeI_hxVtMfM5M14fhTnhCYmzhvqNONoXuRfov3vg\" alt=\"https:\/\/www.guru99.com\/images\/tableau\/060818_0511_TableauConn10.jpg\" title=\"\"><\/figure>\n\n\n\n<p><strong>Step 3: <\/strong>A web data connector window will open. Enter the URL and press enter.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/sknGbmxsZByZkcBRp2Jc1VZ6CIVH9YqcyULIZI9YNaVM8TYgJygfQzybeY6JHduRl7hKPGx0Q3cLzSgkB3Lm2iQbMnilj64WLhDBFhBH1IoHypBVunqILceUBJfCZ4RNty7ZZKp8sSWlJN79uw\" alt=\"https:\/\/help.tableau.com\/current\/pro\/desktop\/en-us\/Img\/example_wdc_error.png\" title=\"\"><\/figure>\n\n\n\n<p>If the web page is displayed, enter the information you&#8217;re prompted for and submit it. Wait while the connector is trying to retrieve the data and then import it as an extract in Tableau.&nbsp;<\/p>\n\n\n\n<p>Select a new worksheet and start your analysis.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>How to make a connection with the Tableau Server?<\/strong><\/h2>\n\n\n\n<p><strong>Step 1: <\/strong>Open the Tableau Desktop.<\/p>\n\n\n\n<p><strong>Step 2: <\/strong>Click on the option <strong>Tableau Server<\/strong> available under option <strong>To a Server.<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/7ZQkoPIzzWtFMl80LhcphsOEATsSXJocn2xCwRVySuNxdKKofBHjd9VfewY5Mfhv0pxfoYqnHS7--cnQSwgvgYTF6_NfVyv_JyMFuAqOsdVr6_NeTjxhT7ye9wETd7JByGBl3k08CuG-LfzpMg\" alt=\"https:\/\/www.guru99.com\/images\/tableau\/060818_0511_TableauConn12.jpg\" title=\"\"><\/figure>\n\n\n\n<p><strong>Step 3: <\/strong>Tableau Server Sign-in window will open.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/cx6l9KBi7t9iPaHZte3BYCp8m74r4KCh9MHuuaEP7yGd_UKPraG2i6CKV6xCSbI9Z_JTu-32P5ZHVydKtlhAIgBRORjWqv7HbkmktFZz0BVw2QAKUy4GHYBlQgiTvB5imkxe44p23RHqX4cYZg\" alt=\"https:\/\/help.tableau.com\/current\/pro\/desktop\/en-us\/Img\/desktopserversignin.png\" title=\"\"><\/figure>\n\n\n\n<p><strong>Step 4: <\/strong>Enter the required fields email id and password, and click on Sign in button.<img fetchpriority=\"high\" decoding=\"async\" alt=\"https:\/\/help.tableau.com\/current\/pro\/desktop\/en-us\/Img\/sign_in.png\" src=\"https:\/\/lh3.googleusercontent.com\/pe4oj3C4bT3id7RMVTzsaAmFn0asWF32xDoB1jVCpF34UKSR0OCl2gWr6RjmYFZZVZtC1JFYFMx5QFcBaooY9MdTNSjuLVX2rTL5eJ-v3YyK1vsxXf5sEzleBE6a5NttzRJRhUAOqwnzX8YlVg\" width=\"250\" height=\"264\" title=\"\"><\/p>\n\n\n\n<p><strong>Step 5: <\/strong>Select the required dataset and import it in Tableau.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/7ox6s2wCGHJc4Hp6P9lAtSq0PVPC5E75hgUakYZZ8c1EJWniB4O9RAfVns2KalnWN5DmEPGiZKo4ECZMjZBMhYxjapI-EunEVM7az2SJW3N6LhvAXEL7fEk21SpNEmxwjFZOs-ImRhL-dh_WyQ\" alt=\"\" title=\"\"><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Data Relationship:<\/strong><\/h2>\n\n\n\n<p>A relational database\/excel consists of tables\/sheets connected by Union and Join to each other.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Joins: <\/strong>Tableau can join up to 32 tables. There are different joins available in Tableau software such as Inner Join, Left Join, Right Join, and Outer Join.<\/li>\n<\/ul>\n\n\n\n<p>First, we will load the tables in the Tableau. The first table is the Employees table containing Employee ID, Birth Date, First Name, Last Name, Gender, and Hire Date. The second table is the Salary table containing Employee ID, Salary, and From Date. Employee ID is the common field in both the tables and will act as a primary key. Hire Date and From Date are the same fields but are having different names. We will drag both the tables.&nbsp;<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/6ott9-BD64XpBPv8xU9V6GqTInFf7_S7RhpduOhLOlxQyZCaWlSH548naZRHeLRGMt8ifCW0fpysAq6DGE1pcutfZBLnl0rQ7SJBRT6jRcIAvwCNu9BBLFrhNALrmWdeyexA1vYeFjo7ShfWQQ\" alt=\"drag the table in tableau join\" title=\"\"><\/figure>\n\n\n\n<p>When both the tables are dragged, an inner join will automatically be created. It is represented by intersecting circles in the picture below:<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/zaJxd8s3kle_sEfSatqQ9xwsa9AfXUaa8R4tjpEYzIBtUJXuym7SLYxN51Ne-XdRTOVy9RpEPC8yA0rWo6WHmdzf_qje7KdUM2nwQDf9idccaxOi_JvEniurdsV8gB1aiQPJjGlRSjbgdw-j7A\" alt=\"drag salary table in tableau joins2\" title=\"\"><\/figure>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Inner Join:<\/strong> It is used to join all the common records between two tables\/sheets. The joining condition is based on the primary key, and there can be more than one joining condition.\u00a0<\/li>\n<\/ol>\n\n\n\n<p>When you click on the intersecting circle, a box will pop-up showing the different types of joins, and the currently applied join is highlighted.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh3.googleusercontent.com\/bS51BhPpzg3J_W6vXHSE3zML93dT5yO4EaVHjZE1tAmBioAGFba5UzwScBs3wT794b58EbuyzK4VF2ZzS3S5oeKunjDGUurppCUml13rPLlbrXTsicTfdXKA_PobPY2ePp08HyCjufjHDhCpNw\" alt=\"intersecting two side\" title=\"\"><\/figure>\n\n\n\n<ol start=\"2\" class=\"wp-block-list\">\n<li><strong>Left Join:<\/strong> It is used to join all the records from the left table and only the common records from the right table.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/AKcI1deBRhYmTbD1CqVpPbnfhRAiLfbYJG8hTDJvFFtXpNNZnCFJqRdsM0HN_VmBUAaGffmb98vNrXgJDwSpPqKhlTd4XXXDhvTHDplA5J3nYiEMWVRHFWBOl1DxVbWVAdp4od59VN6gYjvmCg\" alt=\"left joins \" title=\"\"><\/figure>\n\n\n\n<ol start=\"3\" class=\"wp-block-list\">\n<li><strong>Right Join:<\/strong> It is used to join all the records from the right table and only the common records from the left table.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/QbAKtpTgwWZDWphtBvl31zjUkFWFwYuJ2tC_WVoo75i1nPAqW4Bx87-I_3EJSvbAYXFz2xZdCMfveL9RmRU9kJRnnFqK5aGe35VBoLorCZhp3Qeq8sSez8bcR8gE3YItV7qLX9VherUGXhma4g\" alt=\"right join\" title=\"\"><\/figure>\n\n\n\n<ol start=\"4\" class=\"wp-block-list\">\n<li><strong>Outer Join:<\/strong> It is used to join all the records from both the right and the left table.<\/li>\n<\/ol>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh4.googleusercontent.com\/t3ioIYS3bNzIkhh_OkViD0DK0cy6yLoUkUY9R8uS_niwxiZ2ghMprxAnA-n7JQNEejRTIZJIKVir6CgxGiWfpK7L0jR7QxoyHK3pJIHsGwsdaVBMPM7f-TSAveSBXS-YerHCyO4Fdr9vQU-mEw\" alt=\"use full outer join\" title=\"\"><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Union: <\/strong>Unions are used to append data from two or more tables. Joining condition is not required in Unions. For using Union, tables should have the same header.<\/li>\n<\/ul>\n\n\n\n<p>First, we will drag the tables Air, Land, and Sea in the data window. Then right-click on the table and select <strong>Convert to Union <\/strong>option.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/4WV7RkvquTU5X74kB6rDEPHnte35s5p63OPYDp1oSg8y9mvmc4V0y-gMOXnSjEA58ma1CObhec7GDt6zX1Z-D45PvAgYvjpVlkkr_t46uN2yiOPe7JDwrQgis-WyLHdfThA5QHOZW-6oyUeVyg\" alt=\"https:\/\/www.thedataschool.co.uk\/wp-content\/uploads\/2018\/09\/Blank-data-pane-1024x536.png\" title=\"\"><\/figure>\n\n\n\n<p>Tableau will then automatically append the rows by their common headers.<\/p>\n\n\n\n<p><strong>Before Union:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/SGX8eNAH01xqDJwfSTfSFLBeZi4GT3rUfh8VIwkVrLriHgfrrkie9D1VFMMlwn5XkQhRaMHqFPD-6DO3qtr28TQxGcNiMIfrfPiSu_XvhOcPsmmm7JGTV-tHt_vAkJhYnzf8_m7AcdwjybFCmA\" alt=\"https:\/\/www.thedataschool.co.uk\/wp-content\/uploads\/2018\/09\/Before-union.png\" title=\"\"><\/figure>\n\n\n\n<p><strong>After Union:<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/K-lW3mOuMtgDEkl8Rhx2ZIPg9VLhZ2Jg3WX5IHSwLHflconICZ7nZmFH6oELfdfWbIf8WVKaTu524rUn0V448NoI6FBy8po6Rk_VMxpv4qZsDpNdXec8fwDLakszU8WQN9K_yMbHOR0T3dlBpQ\" alt=\"https:\/\/www.thedataschool.co.uk\/wp-content\/uploads\/2018\/09\/After-union.png\" title=\"\"><\/figure>\n\n\n\n<p><strong>Data Sorting: <\/strong>Tableau allows the sorting of data based on the user requirement. There are two ways of sorting:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li><strong>Computed Sorting:<\/strong> Sort is directly applied on the axis using the <strong>Sort Dialog <\/strong>option.<\/li>\n\n\n\n<li><strong>Manual Sorting:<\/strong> Rearranging the order of dimension fields by dragging them adjacent to each other in an ad-hoc manner.<\/li>\n<\/ol>\n\n\n\n<p>It can be sorted using data sources order like A to Z ascending, Z to A descending, A to Z ascending per table, and Z to A descending per table.<\/p>\n\n\n\n<p>Sorting can be done using the option <strong>Sort Fields<\/strong>, which is present under the Data Source tab.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh6.googleusercontent.com\/TB5ld0oY7iXNetAkHO8CzP0En5pHXCwjKTlC2zDf_H1XD9S-t_b3nrLJfGLMVaGwHZ4P7jN-nhaSp8-rMH9_PYght5bsqvE0vLrygFZuuwdGf36P4T-MMaeLZRxs6x8UHSpe1v08TEyn_WUh0w\" alt=\"Tableau Data Sorting\" title=\"\"><\/figure>\n\n\n\n<p><strong>Replacing Data Source: <\/strong>Multiple data sources can be connected to a single workbook in Tableau. The different sources can be used to create dashboards and sheets in Tableau, but in some cases, we may need to replace the data source with the updated file.<\/p>\n\n\n\n<p>Tableau has a feature named <strong>Replace data source <\/strong>to replace the data source.<\/p>\n\n\n\n<p><strong>Step 1: <\/strong>First, go to the connected data sources.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/OCasNhG6y_2vy9493cSMYI5v-81h5vg2m_O_66I874TGFJAsaUL590on_HRKG-EPHStfEZQuHXKW8Iio5b1GQOTyktxBqEIecBWIESpRwMbfsugLYwoSrnWvURC82DsZQoXMzmiWOEongSJ7hQ\" alt=\"Tableau Replacing Data Source\" title=\"\"><\/figure>\n\n\n\n<p><strong>Step 2: <\/strong>Select the data source that needs to be replaced. Right-click on that source and click on the option Replace Data Source.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/zVPk1NJsEQf1YmJzLEWJABnncIrDW7BX9A2fL-V4xCMipciPgnS3kpW5YWc7IUysdwZtOxA7ZXfSE7TNOsLSvMxmUMfivAthgiLcDN_PTdu4IzdnliTcJ1CE4kziWj8Ga8TY1yZABBDtEW2KJQ\" alt=\"Tableau Replacing Data Source\" title=\"\"><\/figure>\n\n\n\n<p><strong>Step 3: <\/strong>A <strong>Data Source Replacement <\/strong>window will open. Select the <strong>Current<\/strong> and <strong>Replacement <\/strong>option and click on the button, OK.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/lh5.googleusercontent.com\/gq7G0wMKzYqtXM2i5eWOQStMclF1zMNL1fkCV9Mi3tYwBTeQRUOyc9WwKQLup7OUGLaUGgSE6koYCSqgZAgDigdfcXKy9hosnWq9WFNv4jwBW8wV3yNNLh0LrnexIfh0N2Xjxh1Jb6xS_1YGvg\" alt=\"Tableau Replacing Data Source\" title=\"\"><\/figure>\n\n\n\n<p>It will now replace the data source.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Conclusion<\/strong>:<\/h2>\n\n\n\n<p>Establishing reliable data connections in Tableau is vital for ensuring seamless data integration and analysis. By effectively connecting to various data sources, users can leverage Tableau&#8217;s powerful visualization capabilities to make informed decisions.<\/p>\n\n\n\n<p><strong>Key Takeaways<\/strong>:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Tableau supports multiple data sources for comprehensive analysis.<\/li>\n\n\n\n<li>Establishing connections involves setting up secure and optimized data pathways.<\/li>\n\n\n\n<li>Ensuring proper data integration improves performance and report accuracy.<\/li>\n<\/ul>\n\n\n\n<p><strong>Call to Action<\/strong>: Ready to master Tableau&#8217;s data connectivity features? Enroll in <a href=\"https:\/\/www.h2kinfosys.com\/\">H2K Infosys<\/a>&#8216; Tableau training to enhance your data visualization and analysis skills!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tableau can connect with a wide variety of data sources, making it a versatile tool for data analysis. These include Excel files, text files, PDF files, and databases through ODBC connectors. Additionally, Tableau can link with websites, servers, and cloud-based data warehouses, allowing users to bring together diverse datasets for a holistic view of their [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4103,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[804],"tags":[1137,1138,1938,805,1136,495],"class_list":["post-4090","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tableau-tutorials","tag-data-sources","tag-excel-file","tag-replace-data-source","tag-tableau","tag-tableau-data-connection","tag-text"],"_links":{"self":[{"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/posts\/4090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/comments?post=4090"}],"version-history":[{"count":0,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/posts\/4090\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/media\/4103"}],"wp:attachment":[{"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/media?parent=4090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/categories?post=4090"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.h2kinfosys.com\/blog\/wp-json\/wp\/v2\/tags?post=4090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}