3 Replies Latest reply on Apr 13, 2018 12:14 PM by Mike Mainzer

    2 data sources, 1 worksheet

    Justin Gilbert

      I am trying to use 2 data sources in 1 worksheet. There are common data fields in both data sources, however they are not related. Both data sources create the a full list of data. Can anyone direct me on how to use 2 data sources in 1 worksheet?

        • 1. Re: 2 data sources, 1 worksheet
          Justin Gilbert

          As seen below, data is in the worksheet, the data on the left is the 2nd source of data. In the worksheet "Code" in column is the same as "Chief Complaint" on the 2nd data source however they are not related to one another. Currently there are 37 data points in the graph, once I add the 2nd data source, it should go up to 44.

          • 2. Re: 2 data sources, 1 worksheet
            Don Wise

            Hi Justin,

            I realize you're working with public-safety data and might not be able to upload it because of HIPPA and other data-sensitive issues, but is it possible to share the two data sources to the forums so we have a clearer understanding of what you're trying to join to? 

             

            If not, then based on the above screen shot, the only linking field that Tableau is currently recognizing as the same between your two sets of data is your Date Admitted field (gray chain link).  What you're trying to do is blend two sets of data that have differently named field columns, but are essentially the same data types/elements.

             

            If you go to the top menu in Tableau and click on Data, then click on Edit Relationships, a new dialog box will open up; then, click on the radio button Custom, then click on Add and you should see the field column values between the two data sources.  Make sure that Code is highlighted on one side and Chief Complaint is highlighted on the other side and that should cause a recognized blend of the two sets of data based on that linkage.  Examples are provide below:

             

            Screen Shot 2018-04-13 at 10.41.06 AM.png

             

            Screen Shot 2018-04-13 at 10.41.12 AM.png

            Screen Shot 2018-04-13 at 10.41.29 AM.png

             

            Screen Shot 2018-04-13 at 10.45.27 AM.png

            As background, I formerly worked as the Exec. Admin. for a large 9-1-1 center here in LA County (now retired) and we were able to implement Tableau very successfully for our 14 fire departments, so I understand what you're trying to achieve here.  Let me know if I can help any further or if this answered your issue, please mark it as correct so that others will be able to find it.

             

            Thanks, Don

            • 3. Re: 2 data sources, 1 worksheet
              Mike Mainzer

              As Don said, you need to establish a relationship between your two tables.

               

              If they don't have a relationship, you either need to reshape your data so they do have one, add a new data source that will create a new relationship, or create a parameter-calc field combination