But sometimes ONRC categories may be capitalised differently. To be consistent with the use of 'cs' and 'ac' etc. We suggest that ONRC should be converted to lowercase in the input file, and then similarly in the lookup tables. This will reduce errors and be more consistent.
We can consider that ANY text data in the input set that are used in lookups should always be converted to lowercase are part of processing, and then all keys in lookup sets are similarly lowercase.
We currently have a lookup set like this:
But sometimes ONRC categories may be capitalised differently. To be consistent with the use of 'cs' and 'ac' etc. We suggest that ONRC should be converted to lowercase in the input file, and then similarly in the lookup tables. This will reduce errors and be more consistent.
We can consider that ANY text data in the input set that are used in lookups should always be converted to lowercase are part of processing, and then all keys in lookup sets are similarly lowercase.