Extract a number (6-char SIC code) from a string and perform a lookup (2-char SIC to get category)

Danny Roden
Danny Roden Administrator
edited December 2023 in General

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:

Comments

  • Clinton Jones
    Clinton Jones Experian Elite

    There are a couple of ISO 'lists' that i have used to decode abbreviations and encodings using lookups, also in Australia there are a few pieces of public data that ar owned by the states like "Mr Fluffy" data that are useful for identifying traits in property. To be properly useful though, those lists need to be run through batch to ensure the addresses are actually valid.