Hi all,
Pretty new to Alteryx so this may have been answered in some way already, but I'm trying to map STPs based on the CCGs within it (multiple CCGs = 1 STP). I have an Excel with the corresponding CCG to STP, I just need to match the CCGs to their spatial boundaries to be able to map them (please see attached).
For that, I have 3 options: on the ONS website I can either use a .kml, .csv, or a shapefile. From the csv I tried using the create points tool but it's not creating the full polygon, just points - but the .csv contains the CCG names and codes for me to match to the other dataset. From the .kml, I can map the polygons but the CCG names and codes aren't there so I can't match them to their STPs. I'm not sure how to use shapefiles in Alteryx.
The boundaries are here (not attaching them as the files are very large): http://geoportal.statistics.gov.uk/datasets/clinical-commissioning-groups-april-2019-generalised-clipped-boundaries-england
Would someone know how to complete this task? Thank you!
Florence.
