Home > Software > Tableau
Interview Questions   Tutorials   Discussions   Programs   Videos   Discussion   

Tableau - Scenario :- Data Connection to an Excel




1224
views
asked RamPrasad February 20, 2015 06:09 AM  

We have an Excel name 'TEST'with 4 sheets East,West,North,South with same Columns but with different data. We want to get all this data into Tableau. How? what join we have to use?????????


           

2 Answers



 
answered By   0  

after pulling data from excel give the relation ships to which are common columns are there

flag   
   add comment

 
answered By   0  

As the there are four sheets in Excel tableau will consider these sheets as tables. Here you can use Joins provided if there is any common columns among the tables or else you need to use custom SQL where as in 8.2 you need to do using legacy connections to pull the data from the tables.

flag   
   add comment

Your answer

Join with account you already have

FF

Preview


Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!

Alert