2 Replies Latest reply on Jan 11, 2019 6:48 AM by Richard Little

    Joining postcode Census data to another dataset

    Richard Little

      Hi,

       

      I've got an issue with joining postcode census data for population to a dataset I am trying to analyse.

       

      Basically, when I join the data, it aggregates the population by postcode, so if a postcode area appears 10 times in my data it sums the population number 10 times. Is there a simple way to join the data to only show this once, or is there a LOD calc I can use to only show the population figure for a postcode area once?

       

      Thanks in advance