SIC Conversion 🏷️

Danny Roden
Danny Roden Administrator
edited December 2023 in Functions library

Summary

The following package is used in processing Standard Industry Classification (SIC) codes, and were designed to help with post-processing the 2007 variant of the SIC code that is output when performing UK Business data enrichment using Experian cleansing.

Contained within this .dmx package are 2x functions: Convert 2007 SIC Code to Category and Convert Experian SIC Code to Simple SIC Code see below for a brief summary of each:


Convert 2007 SIC Code to Category [Category: Conversion]

image.png

Takes a 2007 format SIC code (in either a ##.## or ##.##/# format) as an input and returns the high level label of the 'category' of businesses which it falls into. Data Source: ONS. These categories can then be used to perform high level grouping, analysis, filtering and segmentation.



See below for a preview of the function definition as well as some sample output results:

image.png


Convert Experian SIC Code to Simple SIC Code [Category: Conversion]

image.png

Converts the SIC code from the format returned by Experian's enrichment services (e.g. 11.10) to the 5-char format used on Company's House (e.g. 01110). This has been built to help 'prepare' data for specific target systmes with specific formats that might differ to the 'default' format output by the Experian cleansing services.


See below for a preview of the function definition as well as some sample output results:

image.png


Compatibility:

These functions are compatible with all instances of Data Studio from v2.1.11 onwards.

[dl-button|Download|https://us.v-cdn.net/6031645/uploads/IEXYTJAAB49N/sic-conversion.dmx]

Tagged:

Categories