Extract a number (6-char SIC code) from a string and perform a lookup (2-char SIC to get category)
Roden, Danny
Administrator
Using some of the Company's House open data, I recently built a simple workflow that extracts the SIC code from a string and then used a lookup table to retrieve the SIC Category (using a 2-char SIC classification) - thought I'd share it on here in case it's of use to anyone (see video
attached).
Also I'm keen to understand, what open data sources you are all using in your Aperture Data Studio environments? Listed below are a below useful ones I've found helpful:
- Official Countries Registerhttps://data.gov.uk/dataset/country-register-2
- SIC Codes & Descriptionshttps://www.ons.gov.uk/methodology/classificationsandstandards/ukstandardindustrialclassificationofeconomicactivities/uksic2007
- Companies House Open Data https://data.gov.uk/dataset/basic-company-data There are also several open data sources of offensi
1