DEFRA / gwa-etl

Azure Function app for GWA ETL activities.
Other
0 stars 1 forks source link

Map office location to known good location during extract #12

Closed st3v3nhunt closed 3 years ago

st3v3nhunt commented 3 years ago

There are over 770 office locations in the raw data with lots of them effectively being duplicates due to typos and casing issues. There are in the region of 250 good office locations. The raw office locations need to be mapped to the good office locations during the extract of data from AAD. The good office locations should include the area code e.g. YRK:York, this is a combination of the area code and the office location. The mapping file will be stored outside of the application, it needs loading and then to be used in ExtractAADData.js.