2 Replies Latest reply on Dec 6, 2013 7:00 AM by Aresh Vas

    Blending files by cases? Is it possible in Tableau?

    Aresh Vas

      Hi Everyone, I have a question about blending two excel files by adding cases. More specifically, I want to add cases or number of participants to another file. Currently, I could add variables or columns but not additional cases.

        • 1. Re: Blending files by cases? Is it possible in Tableau?
          Tracy Rodgers

          Hi Aresh,

           

          What do you mean by cases? Is this a new dimension that will be added to the excel sheets?

           

          -Tracy

          • 2. Re: Blending files by cases? Is it possible in Tableau?
            Aresh Vas

            Hi Tracy,

             

            I have two excel files with the same number of columns (or dimensions), but

            both files are from different years. I am trying to graph change in

            satisfaction score from year 2011 to year 2012 (see example below). In the

            example below, the customers are different but the dimension (satisfaction

            score) are the same.

             

            Currently, I have to combine the two files in excel than export to Tableau.

            In addition, I have to add a dimension  (year) to both files. The problem

            is trying to combine 5 or more files in excel with 2000 or more customer

            IDs in each file.

             

             

            File 1 Year 2012

             

            Customer ID

             

            Satisfaction score

             

            1

             

            4

             

            2

             

            3

             

            3

             

            4

             

            4

             

            6

             

            5

             

            1

             

            ....

             

            1

             

            2034

             

            4

             

            File 2, Year 2012

             

            Customer ID

             

            Satisfaction score

             

            1

             

            5

             

            2

             

            4

             

            3

             

            6

             

            4

             

            6

             

            ....

             

            6

             

            2034

             

            5

             

             

             

             

             

             

            On Thu, Dec 5, 2013 at 1:22 PM, tracyfitzgerald <