Data Interpreter Does Not Give The Table Data When Connecting To Excel With Introductory Text
Published: 25 Mar 2021 Last Modified Date: 25 Mar 2021
Data interpreter does not give the table data when connecting to Excel with introductory text.
Use a named range with Excel
1. Open the excel file, select the table starting from column headers until the end. 2. Click on formulas, and define name. 3. Reconnect the file to Tableau. You will see the defined name in Tableau. Drag that to the data source pane.
Introductory text has to be removed for the correct interpretation of the table.
Thank you for providing your feedback on the effectiveness of the article.