I have a set of codes for different countries which I'd like to divide into groups in order to create a dimension called 'Office'. The field of these codes is called 'MarketCd'.
If the code is 16 or 76, the group should be called 'UK+IR'. If the code is 92 or 93 the group should be called 'Overseas'. For all of the other codes, I want the dimension to create unique value sets which are named with the 'MktDescrip' that corresponds to that 'MarketCd'
The table below may help you understand what I mean: