Transformation tool: PortNumber missing from OED location output

[niamhomalleyjba]

Issue Description

The OED location output does not contain the PortNumber column and I see no reference to it in the ods_tools/odtf/examples/sql/cede_location.sql

Steps to Reproduce (Bugs only)

Config file:

transformations:
  loc: # Transformation name
    input_format:
      name: Cede_Location
      version: 10.0.0
    output_format:
      name: OED_Location
      version: 3.0.2
    runner:
      batch_size: 750 # Number of rows to process in a single batch
    extractor:
      type: mssql # Path to the DB connection file. Other options are 'postgres' and 'sqlite'. Defaults to 'csv', when not present.
      options:
        host: myserver, 1450
        port:
        database: MY_DB
        user: foo
        password: bar
        sql_statement: ./cede_location.sql # SQL statement to extract data
    loader:
      options:
        path: ./oed_location.csv # Path to the output file
        quoting: minimal

Command used:

ods_tools transform --config-file /path/to/config.yaml --nocheck

Output is created but the PortNumber column is missing from the output.

Version / Environment information

Name: ods_tools
Version: 3.2.7

Example data / logs