Agree with Shin Sir! You've to union your sources.There are several way to union the data.
Consolidate all your excel files in a single workbook separated by sheets. Once done then connect the consolidated file and drag all other sheets on top of first sheet to union. If you don't want to consolidate then follow the other approach
Convert your excel worksheets to individual .csv and put all text files in a folder then connect any one csv file, tableau will automatically list down all the csv from your directory in Sheets sections. Make sure data structure of all the files are identical and column sequence is also same. Then connect any one .csv drag other sources on top of connected source to union all the files. You may find several links and online help over net about union. See the screenshot basic blueprint of your data structure should looks like this
Let us know if this help.
Hi Shin and Mahfooj,
Thanks for responding. But, my two excel data sources contains multiple worksheets which are of 12 in one and 10 in another. Also, each worksheet contains 12 columns in each in excel 1 and other excel 2 contains 10 columns each. I understand your answer if the data is in a single worksheet in two sources. But, how to handle the situation when there are multiple worksheets? Please let me know. Many thanks!
1 of 1 people found this helpful
See you've to work on your data source first. You've to use any ETL tool or database system to consolidate those files in a system table. Or you can download Tableau prep/ Alteryx trial versions to play with the tool. But if this activity is for long term you have to use any database system to manage your data source. Tableau is a data visualization tool. If you thinks ETL can be done in tableau then its difficult. Hope you get my point.