4 Replies Latest reply on Jan 20, 2017 9:07 AM by Abed Jaji

How to rename Table names either under Data Source or Sheet tab?

Abed Jaji Jan 20, 2017 8:17 AM

I would like to know how to rename table names. I have connected Tableau 10.1.3 to oracle database and joined 4 tables in the Data Source. These tables i have joined are called cst_customer, cst_email, cst_address, trn_Line_item and I would simply like to rename them to Customer, Email, Address and Transactions either if possible in Data Source section or in the Sheet section under Measures & Dimensions. Please refer to attachment for a snapshot of the tables mapped.

Example.PNG 45.8 KB

1. Re: How to rename Table names either under Data Source or Sheet tab?

Shyamal Patel Jan 20, 2017 8:25 AM (in response to Abed Jaji)

Hi Abed,

One simple way to do that is...

Once you connect your tables in Tableau, go to a new worksheet. On the data pane (left side) you will see your data tables. Just right click and rename. It will be renamed and also you will see the new name when u go to Data Source tab too.

Hope this helps
Like Show 0 Likes(0)

Actions
2. Re: How to rename Table names either under Data Source or Sheet tab?

Abed Jaji Jan 20, 2017 8:35 AM (in response to Shyamal Patel)

In a new sheet under Data pane on the left side when i right click on the tables the only option i see is 'Remove Table'. I see the rename option once i click on the columns but i don't see when right click on the table.
Like Show 0 Likes(0)

Actions
3. Re: How to rename Table names either under Data Source or Sheet tab?

chris monger Jan 20, 2017 8:51 AM (in response to Abed Jaji)

I'm not sure if it works for Oracle, but on the data sources I've used if you double click on the table name on the data source tab it should give you the option to change the table name.
3 of 3 people found this helpful
Like Show 1 Likes(1)

Actions
4. Re: How to rename Table names either under Data Source or Sheet tab?

Abed Jaji Jan 20, 2017 9:07 AM (in response to chris monger)

Yes actually that worked. Under Data Source tab i double clicked on the name of the table where the mapping is done and it allowed me to rename it. That's the only way it worked for me. Thanks a lot!
Like Show 2 Likes(2)

Actions