5 Replies Latest reply on Jun 15, 2016 2:23 PM by Sam McKnight

Change The Primary Table In A Data Source

John Bartlett Apr 26, 2016 2:35 AM

So, say I create a Data Source based off a single fact table, call it T_FACT_ENTRIES. The I hang my dimensions off it, sort out my measures, etc etc.

Then a while later, there's a new version of that fact table called V_FACT_ENTRIES with the same columns and I want to switch from T_ to V_.

If I take a copy of the data source and remove T_FACT_ENTRIES everything goes and I find that my only option is start from scratch with V_FACT_ENTRIES and do every thing again, which is quite arduous.

How can I replace the one with the other?

1. Re: Change The Primary Table In A Data Source

Sharad Adhikari Apr 26, 2016 2:43 AM (in response to John Bartlett)

Hi John,

Did you try edit connection and choose the V_FACT_ENTRIES table? Right click on data source T_FACT_ENTRIES and choose Edit data source. Choose the V_FACT_ENTRIES table from window browser. Let me know if you still have to start from the scratch.

BR
Sharad
Like Show 0 Likes(0)

Actions
2. Re: Change The Primary Table In A Data Source

Fabian Zimmer Apr 26, 2016 2:51 AM (in response to John Bartlett)

Hi John,

The answer is surprisingly simple. Just drag the new fact table over the old to swap them out (the complete table pill will be highlighted with a blue border).
This way you won't have to start from scratch.

Best,
Fabian
InterWorks Europe
1 of 1 people found this helpful
Like Show 3 Likes(3)

Actions
3. Re: Change The Primary Table In A Data Source

John Bartlett Apr 26, 2016 3:42 AM (in response to Fabian Zimmer)

Fabian

That's amazing. You've just made a couple of people very happy and slightly awestruck.

Thanks

John
Like Show 2 Likes(2)

Actions
4. Re: Change The Primary Table In A Data Source

Fabian Zimmer Apr 26, 2016 4:11 AM (in response to John Bartlett)

Hey John,

Happy to hear that! Sometimes it's the simple things in life.

Best,
Fabian
InterWorks Europe
Like Show 0 Likes(0)

Actions
5. Re: Change The Primary Table In A Data Source

Sam McKnight Jun 15, 2016 2:23 PM (in response to Fabian Zimmer)

Just wanted to say I've been searching for this feature for two years now. I'm so appreciative that you had an answer in Fabian.
Like Show 0 Likes(0)

Actions

Go to original post

Tableau Community Forums

Change The Primary Table In A Data Source

1. Re: Change The Primary Table In A Data Source

2. Re: Change The Primary Table In A Data Source

3. Re: Change The Primary Table In A Data Source

4. Re: Change The Primary Table In A Data Source

5. Re: Change The Primary Table In A Data Source

Actions

More Like This