Best option here is to create a mapping here and use as your config.
Here even if you use switch statements, it’ll support only those hard coded values.
If in future you need to add support for a new location, you’ll have to add a new case inside the switch for getting the correct value for it rather than specifying others.
I usually make dictionaries out of my configuration files - Excel
so if i had used those here my code would be like,
if dictionary.ContainsKey(Variable.text) then
Final_Variable = dictionary.Value(Variable.text)
Final Variable = "Others"
You could learn how to make use of dictionary variables very quickly online.
Creating a dictionary with required values is something you’ll feel tedious to do in the beginning, but believe me, it surely has many pros.
One other way to achieve this similar result is by using LINQ and by that way you’ll not have to convert all your excel configurations into dictionaries, simply having all those excel’s read into datatable and grouped into a Dataset will work wonders.