I've searched the posts and haven't found something that may be able to help me.
I have a report that displays country name but it displays the ISO 2 digit Country Code such as "BR" for Brazil. I have in Excel the ISO 2 digit codes and the corresponding full country name to each code in format "BRBrazil".
Any ideas on how to setup a query in BO that essentialls says something like if Country Name = the first two digits of the data in Excel, which I can import, then display the full country name only.
I've been trying If statement as well as Match but I can't seem to get it right.
Thanks all.
Leo
I have a report that displays country name but it displays the ISO 2 digit Country Code such as "BR" for Brazil. I have in Excel the ISO 2 digit codes and the corresponding full country name to each code in format "BRBrazil".
Any ideas on how to setup a query in BO that essentialls says something like if Country Name = the first two digits of the data in Excel, which I can import, then display the full country name only.
I've been trying If statement as well as Match but I can't seem to get it right.
Thanks all.
Leo