2 Replies Latest reply on Feb 22, 2018 9:40 AM by Deepak Rai

    Can we combine 2 packaged workbook in one with their extract

    Ram Nagar

      Hi,

      I have 2 packaged workbooks calculated differently from same data source but i am doing calculation through custom sql in each workbook so i don't end up putting lot of filters in sheets also i can show summary dashboard for multiple metrics together which are for same project. but i wanted to combine both which i know we can do. but i wanted to know when we published combined workbook to server does the refresh happens for both extracts can schedule for both same time or different time. is it a good practice

        • 1. Re: Can we combine 2 packaged workbook in one with their extract
          Amber Loranger

          Hello Ram,

          I don't understand exactly what you mean by combining the workbook. It would be very helpful to have some screenshots, the twbx files, or a more thorough description of what you would like to achieve. However I do have some thoughts based on what you have shared above:

          If you are using different custom SQL in each workbook, these are different data sources according to Tableau, even though they are based on the same database.

           

          If you want to use one published data source for the two workbooks, I would recommend publishing one data source that is set up so it works for both, and then creating calculations/filters in the separate workbooks for the information you need to be different.

           

          If you mean you want to actually copy all the sheets into a single workbook, but half the sheets will use one data source (one custom sql query) and half another, this is also fine. The two separate sql queries will be treated as two separate data sources. You will need to choose whether you want to publish the data sources separately from the workbook or not, and how often they will refresh. https://onlinehelp.tableau.com/current/pro/desktop/en-us/help.html#publish_overview.html has more information on publishing workbooks and data sources.

           

          Hope this helps!

          • 2. Re: Can we combine 2 packaged workbook in one with their extract
            Deepak Rai

            You can import one into another and can still refresh