You can do these on the Data Source Tab by simply adding a two new calculated fields and right clicking and renaming the columns.
If you are wanting to use this to get your data into a format before using another system to interpret it, I would suggest Tableau Prep as you can do a lot more with it.
Sample1.twbx 12.6 KB
Hi Andrew, thanks for your reply.
If I manually change the source data, does this will remain if I connect to a similar excel file or change data source link?
Best of regards.
Yes, you can change the underlying data and the extra columns will remain with the headers keeping their changed name. The exception to this would be if the underlying data changed headers it would add the new headers in as additional columns.
Thanks Andrew, really appreciate it!