Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
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:
MktDescrip | MarketCd | Office |
UK | 16 | UK+IR |
Belgium | 15 | Belgium |
Portugal | 10 | Portugal |
France | 12 | France |
USA | 46 | USA |
Spain | 11 | Spain |
Ireland | 76 | UK+IR |
Asia | 92 | Overseas |
Oceania | 93 | Overseas |
Do you have any ideia how should I do This?
Thank you!
Maybe this will br helpful:
If(MarketCd=16 or MarketCd=76, 'UK+IR',
If(MarketCd=92 or MarketCd=93, 'Overseas', MktDescrip))
Hi Sofia,
You can also try,
If(Match(MarketCd, 92,93), 'Overseas', MktDescrip))
I would suggest you to create this field in script level. Have a nice day.