1 Reply Latest reply on Sep 25, 2014 12:31 PM by Justin Emerick

    joining tables

    Jerry Pudmanski

      First time working in JOINS and my data is off.

       

      I am trying to get the scores for the locations attached but he scores are way off.  I am assuming its a join thing b/c if I take the files individually I get the data I need. Start doing the joins and I am way off.   Is there something I am doing wrong to get the bad data?

       

      Thanks

        • 1. Re: joining tables
          Justin Emerick

          It appears that you have one to many relationships. If you have measures that need to be aggregated, joining the data will duplicate that record across all the unique values at a lower granularity.

           

          Since the granularity are different, you may be able to accomplish what you are trying to do with data blending (connect to each worksheet individually).

           

          Justin