Skip navigation

Pivot 2+ data sources prior to join

score 16
You have not voted. Active

***Apologies in advanced if this a) can be done or b) is already listed as an idea, I have searched the forums / ideas, the forums advised this can not be achieved (Re: Multiple Pivots ) and I could not find an idea that was similar.***

 

What is your idea?

 

Enable more than 1 pivot on multiple data sources prior to joining the data sources

 

What problem are you trying to solve or what scenario would this idea solve?

 

  • I have 3 MS Excel data sources
  • In 2 sources I need to pivot 4 columns so that I can then join them based on the pivoted column
  • In Tableau, I can achieve this for the first data source however when attempting a pivot with the second data source Tableau gets rowdy, starts a bar fight and doesn't allow the pivot
  • Therefore this forces me (kicks me in the guts) to pivot the data sources in MS Excel first. As this process will be run on regular basis this adds another step to this process which in-turn adds another layer for error.

 

What workaround have you found and used so far (if any)?

 

See above, MS Excel (shudder, sad face).

 

What is your role in your organization?

 

Operations Manager

Comments

Vote history