Change the schema of the file "price_subm_2023.csv" so that column headings are generic, similar to a global reference table.
Current
entity | year | balance_type | service | asset_category | cost_driver | year_operational | notes | regulatory_life | tax_life | amount
New
entity | year | category1 | category2 | category3 | category4 | category5 | notes | value1 | value2 | value3
Underlying code selecting on these columns will then need to be refactored.
Change the schema of the file "price_subm_2023.csv" so that column headings are generic, similar to a global reference table.
Current
entity | year | balance_type | service | asset_category | cost_driver | year_operational | notes | regulatory_life | tax_life | amount
New
entity | year | category1 | category2 | category3 | category4 | category5 | notes | value1 | value2 | value3
Underlying code selecting on these columns will then need to be refactored.