You can implement Data Appending Methodology,
How can show the Data when data is located 3 different sheets in the single
Below are the XL sheets, where having data for 3 Countries in 3 Sheets.
1) All 3 Sheets are located in single XL Workbook.
2) Connect XL workbook (Sheet 1) to Tableau.
3) Then Extract the Data.
4) Connect to the Same XL workbook Sheet2.
5) Define the Relationship Between DB1 & DB2. Then Right click first DB
Extract, click on "Append data from data source". Then refresh Extract
6) Now we are having data fro 3 Countries (Which are located in 3 XL sheets
in 1 Workbook.)
On Wed, Sep 9, 2015 at 12:18 AM, Courtney Connolly <
Thanks for your reply. However, I don't think this quite gets me what I'm looking for. My data is in separate Excel files, rather than the same file. Additionally, the data is not structured the same. For example, 1 data set contains activity and records for 2014 and represents the type of sales person in a field called "Type" and they are either an Apprentice=K or a Consultant=B. My 2015 data set represents this same information in a field called "Status" and the identifier is also different than the 2014 file: Apprentice=Apprentice and Consultant=Consultant. In Excel I can link the separate files to a third file and write different logic formulas to count the number of Apprentices for each year and measure their respective activity levels. So for 2014 I would use =Countif(Type[range],"K") and for 2015 it would be =Countif(Status[range],"Apprentice"). Can I do something similar in Tableau?