I have a list of 1000s of ID's in a table which stand for user friendly names that are not in the database. I have the translation in a separate spreadsheet. How can I get Tableau to use the spreadsheet for the aliases?
As far as I know, aliases are 100% manual, so you can't just load them from a list. But you can either load the spreadsheet data into your database and do a join (best option) or try data blending in Tableau (prepare for headache).