KNOWLEDGE BASE

How to make an Excel list of Tableau Desktop Aliases


Published: 12 Sep 2023
Last Modified Date: 12 Sep 2023

Question

When you replace the data source in Tableau Desktop, the aliases of the original data source are not inherited. 
How can I make an Excel list of Tableau Desktop Aliases for references?

Environment

  • Tableau Desktop

Answer

1. Start 2 instances of Tableau Desktop and open one data source in each of them, one using the original name, and the one is the data sourcing using the aliases.
2. Export the data to CSV on these 2 data sources. 
User-added image
3. Open these 2 CSV in Excel, and copy the columns with the aliases into one Excel file.
User-added image
4. Select these 2 columns and click advanced - Unique records only.
User-added image

5. You will get a list of Aliases changes chart. 
User-added imageUser-added image
Did this article resolve the issue?