-
2. Re: I have two Excel workbooks. One has 12 worksheets with 12 columns in each and the other has 10 worksheets with 10 columns in each. I want to show only 12 columns as the output. How to achieve this?
Mahfooj Khan Jan 17, 2019 10:19 PM (in response to siva sandeep)Hi,
Agree with Shin Sir! You've to union your sources.There are several way to union the data.
Option 1:
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
Option 2:
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.
Mahfooj
-
3. Re: I have two Excel workbooks. One has 12 worksheets with 12 columns in each and the other has 10 worksheets with 10 columns in each. I want to show only 12 columns as the output. How to achieve this?
siva sandeep Jan 18, 2019 1:12 AM (in response to Mahfooj Khan)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!
Regards,
Siva.
-
4. Re: I have two Excel workbooks. One has 12 worksheets with 12 columns in each and the other has 10 worksheets with 10 columns in each. I want to show only 12 columns as the output. How to achieve this?
Mahfooj Khan Jan 19, 2019 10:34 PM (in response to siva sandeep)1 of 1 people found this helpfulSee 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.
Mahfooj