Advertisement
Guest User

Untitled

a guest
Dec 18th, 2014
172
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 9.93 KB | None | 0 0
  1. CASE [Country]
  2. WHEN "---" THEN "RoW"
  3. WHEN "Unknown" THEN "RoW"
  4. WHEN "AbuDhabi" THEN "EMEA"
  5. WHEN "Afghanistan" THEN "EMEA"
  6. WHEN "Åland Islands" THEN "EMEA"
  7. WHEN "Aland Islands" THEN "EMEA"
  8. WHEN "Albania" THEN "EMEA"
  9. WHEN "Algeria" THEN "EMEA"
  10. WHEN "American Samoa" THEN "APAC"
  11. WHEN "Andorra" THEN "EMEA"
  12. WHEN "Angola" THEN "EMEA"
  13. WHEN "Anguilla" THEN "LATAM"
  14. WHEN "Anguilla (BWI)" THEN "LATAM"
  15. WHEN "Antartica" THEN "RoW"
  16. WHEN "Antigua and Barbuda" THEN "LATAM"
  17. WHEN "Antigua & Barbuda (BWI)" THEN "LATAM"
  18. WHEN "Argentina" THEN "LATAM"
  19. WHEN "Armenia" THEN "EMEA"
  20. WHEN "Aruba" THEN "LATAM"
  21. WHEN "Aruba (Neth. Antilles)" THEN "LATAM"
  22. WHEN "Australia" THEN "APAC"
  23. WHEN "Austria" THEN "EMEA"
  24. WHEN "Azerbaijan" THEN "EMEA"
  25. WHEN "Bahamas" THEN "LATAM"
  26. WHEN "Bahrain" THEN "EMEA"
  27. WHEN "Bangladesh" THEN "APAC"
  28. WHEN "Barbados" THEN "LATAM"
  29. WHEN "Barbados (BWI)" THEN "LATAM"
  30. WHEN "Belarus" THEN "EMEA"
  31. WHEN "Belgium" THEN "EMEA"
  32. WHEN "Belize" THEN "LATAM"
  33. WHEN "Belize (BWI)" THEN "LATAM"
  34. WHEN "Belize (Br. Honduras)" THEN "LATAM"
  35. WHEN "Benin" THEN "EMEA"
  36. WHEN "Bermuda" THEN "LATAM"
  37. WHEN "Bhutan" THEN "EMEA"
  38. WHEN "Bolivia" THEN "LATAM"
  39. WHEN "Bonaire, Saint Eustatius and Saba" THEN "LATAM"
  40. WHEN "Bosnia and Herzegovina" THEN "EMEA"
  41. WHEN "Bosnia-Herzegovina" THEN "EMEA"
  42. WHEN "Botswana" THEN "EMEA"
  43. WHEN "Bouvet Island" THEN "EMEA"
  44. WHEN "Brazil" THEN "LATAM"
  45. WHEN "British Indian Ocean Territory" THEN "EMEA"
  46. WHEN "Brunei Darussalam" THEN "EMEA"
  47. WHEN "Bulgaria" THEN "EMEA"
  48. WHEN "Burkina Faso" THEN "EMEA"
  49. WHEN "Burundi" THEN "EMEA"
  50. WHEN "Cambodia" THEN "APAC"
  51. WHEN "Cambodia (Kampuchea)" THEN "APAC"
  52. WHEN "Cameroon" THEN "APAC"
  53. WHEN "Canada" THEN "CAN"
  54. WHEN "Cape Verde" THEN "LATAM"
  55. WHEN "Cayman Islands" THEN "LATAM"
  56. WHEN "Cayman Islands (BWI)" THEN "LATAM"
  57. WHEN "Central African Republic" THEN "EMEA"
  58. WHEN "Chad" THEN "EMEA"
  59. WHEN "Chile" THEN "LATAM"
  60. WHEN "China" THEN "APAC"
  61. WHEN "China, Peoples Rep." THEN "APAC"
  62. WHEN "Christmas Island" THEN "APAC"
  63. WHEN "Cocos (Keeling) Islands" THEN "APAC"
  64. WHEN "Colombia" THEN "LATAM"
  65. WHEN "Congo" THEN "EMEA"
  66. WHEN "Congo (DRC)" THEN "EMEA"
  67. WHEN "CONGO DEMOCRATIC REP" THEN "EMEA"
  68. WHEN "Congo (Republic)" THEN "EMEA"
  69. WHEN "Congo, The Democratic Republic of the" THEN "EMEA"
  70. WHEN "Cook Islands" THEN "APAC"
  71. WHEN "Costa Rica" THEN "LATAM"
  72. WHEN "Cote d'Ivoire" THEN "EMEA"
  73. WHEN "Côte d'Ivoire" THEN "EMEA"
  74. WHEN "Croatia" THEN "EMEA"
  75. WHEN "Curacao" THEN "LATAM"
  76. WHEN "Curaçao" THEN "LATAM"
  77. WHEN "Cyprus" THEN "EMEA"
  78. WHEN "Czech Republic" THEN "EMEA"
  79. WHEN "Denmark" THEN "EMEA"
  80. WHEN "Djibouti" THEN "EMEA"
  81. WHEN "Djibouti Rep." THEN "EMEA"
  82. WHEN "Dominica" THEN "LATAM"
  83. WHEN "Dominican Republic" THEN "LATAM"
  84. WHEN "Dubai" THEN "EMEA"
  85. WHEN "Ecuador" THEN "LATAM"
  86. WHEN "Egypt" THEN "EMEA"
  87. WHEN "Egypt, Arab Rep. of" THEN "EMEA"
  88. WHEN "El Salvador" THEN "LATAM"
  89. WHEN "Equatorial Guinea" THEN "EMEA"
  90. WHEN "Eritrea" THEN "EMEA"
  91. WHEN "Estonia" THEN "EMEA"
  92. WHEN "Ethiopia" THEN "EMEA"
  93. WHEN "Falkland Islands (Malvinas)" THEN "LATAM"
  94. WHEN "Faroe Islands" THEN "APAC"
  95. WHEN "Fiji" THEN "APAC"
  96. WHEN "Finland" THEN "EMEA"
  97. WHEN "France" THEN "EMEA"
  98. WHEN "French Guiana" THEN "LATAM"
  99. WHEN "French Polynesia" THEN "APAC"
  100. WHEN "Gabon" THEN "EMEA"
  101. WHEN "Gabon Rep." THEN "EMEA"
  102. WHEN "Gambia" THEN "EMEA"
  103. WHEN "Georgia" THEN "EMEA"
  104. WHEN "Germany" THEN "EMEA"
  105. WHEN "Ghana" THEN "EMEA"
  106. WHEN "Gibraltar" THEN "EMEA"
  107. WHEN "Greece" THEN "EMEA"
  108. WHEN "Greenland" THEN "EMEA"
  109. WHEN "Grenada" THEN "LATAM"
  110. WHEN "Grenada (BWI)" THEN "LATAM"
  111. WHEN "Guadeloupe" THEN "LATAM"
  112. WHEN "Grenadines & St. Vinc." THEN "LATAM"
  113. WHEN "Guam" THEN "APAC"
  114. WHEN "Guatemala" THEN "LATAM"
  115. WHEN "Guernsey" THEN "EMEA"
  116. WHEN "Guinea" THEN "EMEA"
  117. WHEN "Guinea-Bissau" THEN "EMEA"
  118. WHEN "Guyana" THEN "EMEA"
  119. WHEN "Haiti" THEN "LATAM"
  120. WHEN "Holy See (Vatican City State)" THEN "EMEA"
  121. WHEN "Honduras" THEN "LATAM"
  122. WHEN "Honduras, Rep. of" THEN "LATAM"
  123. WHEN "Hong Kong" THEN "APAC"
  124. WHEN "Hungary" THEN "EMEA"
  125. WHEN "Iceland" THEN "EMEA"
  126. WHEN "India" THEN "APAC"
  127. WHEN "Indonesia" THEN "APAC"
  128. WHEN "Iran" THEN "EMEA"
  129. WHEN "Iran, Islamic Republic of" THEN "EMEA"
  130. WHEN "Iraq" THEN "EMEA"
  131. WHEN "Ireland" THEN "EMEA"
  132. WHEN "Isle of Man" THEN "EMEA"
  133. WHEN "Israel" THEN "EMEA"
  134. WHEN "Italy" THEN "EMEA"
  135. WHEN "Jamaica" THEN "LATAM"
  136. WHEN "Jamaica (BWI)" THEN "LATAM"
  137. WHEN "Japan" THEN "APAC"
  138. WHEN "Jersey" THEN "EMEA"
  139. WHEN "Jordan" THEN "EMEA"
  140. WHEN "Kazakhstan" THEN "EMEA"
  141. WHEN "Kenya" THEN "EMEA"
  142. WHEN "Kiribati" THEN "APAC"
  143. WHEN "Korea, Democratic People's Republic of" THEN "APAC"
  144. WHEN "Korea, Republic of" THEN "APAC"
  145. WHEN "Korea, Rep. of (South)" THEN "APAC"
  146. WHEN "Kuwait" THEN "EMEA"
  147. WHEN "Kyrgyzstan" THEN "EMEA"
  148. WHEN "Lao People's Democratic Republic" THEN "APAC"
  149. WHEN "Laos, Peoples Dem. Rep. of" THEN "APAC"
  150. WHEN "Latvia" THEN "EMEA"
  151. WHEN "Lebanon" THEN "EMEA"
  152. WHEN "Lesotho" THEN "EMEA"
  153. WHEN "Liberia" THEN "EMEA"
  154. WHEN "Libyan Arab Jamahiriya" THEN "EMEA"
  155. WHEN "Liechtenstein" THEN "EMEA"
  156. WHEN "Lithuania" THEN "EMEA"
  157. WHEN "Luxembourg" THEN "EMEA"
  158. WHEN "Macao" THEN "APAC"
  159. WHEN "Macao (Macau)" THEN "APAC"
  160. WHEN "Macedonia" THEN "EMEA"
  161. WHEN "Macedonia (FYROM)" THEN "EMEA"
  162. WHEN "Macedonia, the former Yugoslav Republic of" THEN "EMEA"
  163. WHEN "Madagascar" THEN "EMEA"
  164. WHEN "Madagascar, Dem. Rep." THEN "EMEA"
  165. WHEN "Malawi" THEN "EMEA"
  166. WHEN "Malaysia" THEN "APAC"
  167. WHEN "Maldives" THEN "APAC"
  168. WHEN "Mali" THEN "APAC"
  169. WHEN "Malta" THEN "EMEA"
  170. WHEN "Marshall Islands" THEN "US"
  171. WHEN "Martinique" THEN "LATAM"
  172. WHEN "Martinique (French Ant.)" THEN "LATAM"
  173. WHEN "Mauritania" THEN "EMEA"
  174. WHEN "Mauritius" THEN "EMEA"
  175. WHEN "Mauritius Is." THEN "EMEA"
  176. WHEN "Mayotte" THEN "EMEA"
  177. WHEN "MAYOTTE" THEN "EMEA"
  178. WHEN "Mexico" THEN "LATAM"
  179. WHEN "Micronesia" THEN "APAC"
  180. WHEN "Micronesia, Federated States of" THEN "APAC"
  181. WHEN "Moldova" THEN "EMEA"
  182. WHEN "Moldova, Republic of" THEN "EMEA"
  183. WHEN "Monaco" THEN "EMEA"
  184. WHEN "Mongolia" THEN "APAC"
  185. WHEN "Mongolian Peoples Rep." THEN "APAC"
  186. WHEN "Montenegro" THEN "EMEA"
  187. WHEN "Montserrat" THEN "LATAM"
  188. WHEN "Morocco" THEN "EMEA"
  189. WHEN "Mozambique" THEN "EMEA"
  190. WHEN "Myanmar" THEN "APAC"
  191. WHEN "Myanmar (Burma)" THEN "APAC"
  192. WHEN "Namibia" THEN "EMEA"
  193. WHEN "Southwest Africa/Namibia" THEN "EMEA"
  194. WHEN "Nauru" THEN "APAC"
  195. WHEN "Nepal" THEN "APAC"
  196. WHEN "Netherlands" THEN "EMEA"
  197. WHEN "Netherlands Antilles" THEN "EMEA"
  198. WHEN "New Caledonia" THEN "EMEA"
  199. WHEN "New Zealand" THEN "APAC"
  200. WHEN "Nicaragua" THEN "LATAM"
  201. WHEN "Niger" THEN "EMEA"
  202. WHEN "Nigeria" THEN "EMEA"
  203. WHEN "Nigeria, Fed. Rep." THEN "EMEA"
  204.  
  205. WHEN "Niue" THEN "APAC"
  206. WHEN "North Africa" THEN "EMEA"
  207. WHEN "Northern Mariana Islands" THEN "LATAM"
  208. WHEN "Norway" THEN "EMEA"
  209. WHEN "Oman" THEN "EMEA"
  210. WHEN "Other" THEN "RoW"
  211. WHEN "Pakistan" THEN "EMEA"
  212. WHEN "Palau" THEN "APAC"
  213. WHEN "Palestinian Territory, Occupied" THEN "EMEA"
  214. WHEN "PALESTINIAN TERRITORIES" THEN "EMEA"
  215. WHEN "Panama" THEN "LATAM"
  216. WHEN "Papua New Guinea" THEN "APAC"
  217. WHEN "Paraguay" THEN "LATAM"
  218. WHEN "Peru" THEN "LATAM"
  219. WHEN "Philippines" THEN "APAC"
  220. WHEN "Pitcairn" THEN "APAC"
  221. WHEN "Poland" THEN "EMEA"
  222. WHEN "Portugal" THEN "EMEA"
  223. WHEN "Portugal, Madeira & Azores" THEN "EMEA"
  224. WHEN "Puerto Rico" THEN "LATAM"
  225. WHEN "Qatar" THEN "EMEA"
  226. WHEN "Reunion" THEN "EMEA"
  227. WHEN "Réunion" THEN "EMEA"
  228. WHEN "Romania" THEN "EMEA"
  229. WHEN "Russian Federation" THEN "EMEA"
  230. WHEN "Russia" THEN "EMEA"
  231. WHEN "Rwanda" THEN "EMEA"
  232. WHEN "Saint Barthélemy" THEN "EMEA"
  233. WHEN "Saint Helena" THEN "EMEA"
  234. WHEN "Saint Kitts and Nevis" THEN "LATAM"
  235. WHEN "Saint Lucia" THEN "LATAM"
  236. WHEN "Saint Martin (French part)" THEN "LATAM"
  237. WHEN "Saint Martin" THEN "LATAM"
  238. WHEN "Saint Pierre and Miquelon" THEN "EMEA"
  239. WHEN "Samoa" THEN "APAC"
  240. WHEN "San Marino" THEN "EMEA"
  241. WHEN "Saudi Arabia" THEN "EMEA"
  242. WHEN "Senegal" THEN "EMEA"
  243. WHEN "Serbia" THEN "EMEA"
  244. WHEN "Seychelles" THEN "EMEA"
  245. WHEN "Sharjah" THEN "EMEA"
  246. WHEN "Sierra Leone" THEN "EMEA"
  247. WHEN "Singapore" THEN "APAC"
  248. WHEN "Singapore, Rep. of" THEN "APAC"
  249. WHEN "Sint Maarten" THEN "LATAM"
  250. WHEN "Slovakia" THEN "EMEA"
  251. WHEN "Slovenia" THEN "EMEA"
  252. WHEN "Solomon Islands" THEN "APAC"
  253. WHEN "Somalia" THEN "EMEA"
  254. WHEN "Somali Rep." THEN "EMEA"
  255. WHEN "South Africa" THEN "EMEA"
  256. WHEN "South Africa, Rep. of" THEN "EMEA"
  257. WHEN "South Georgia and the South Sandwich Islands" THEN "LATAM"
  258. WHEN "Spain" THEN "EMEA"
  259. WHEN "Sri Lanka" THEN "APAC"
  260. WHEN "Sri Lanka (Ceylon)" THEN "APAC"
  261. WHEN "Saint Vincent and the Grenadines" THEN "LATAM"
  262. WHEN "St. Vincent & Grenadines" THEN "LATAM"
  263. WHEN "St.Vincent & Grenadines" THEN "LATAM"
  264. WHEN "Suriname" THEN "LATAM"
  265. WHEN "Suriname, Rep. of" THEN "LATAM"
  266. WHEN "Svalbard and Jan Mayen" THEN "EMEA"
  267. WHEN "Swaziland" THEN "EMEA"
  268. WHEN "Sweden" THEN "EMEA"
  269. WHEN "Switzerland" THEN "EMEA"
  270. WHEN "Syrian Arab Republic" THEN "EMEA"
  271. WHEN "Taiwan" THEN "APAC"
  272. WHEN "Taiwan (Rep. of China)" THEN "APAC"
  273. WHEN "Tajikistan" THEN "EMEA"
  274. WHEN "Tanzania, United Republic of" THEN "EMEA"
  275. WHEN "Tanzania (Zanzibar)" THEN "EMEA"
  276. WHEN "Thailand" THEN "APAC"
  277. WHEN "Timor-Leste" THEN "APAC"
  278. WHEN "Togo" THEN "EMEA"
  279. WHEN "Tokelau" THEN "APAC"
  280. WHEN "Tonga" THEN "APAC"
  281. WHEN "Trinidad and Tobago" THEN "LATAM"
  282. WHEN "Trinidad & Tobago (BWI)" THEN "LATAM"
  283. WHEN "Tunisia" THEN "EMEA"
  284. WHEN "Turkey" THEN "EMEA"
  285. WHEN "Turkmenistan" THEN "EMEA"
  286. WHEN "Turks and Caicos Islands" THEN "LATAM"
  287. WHEN "Tuvalu" THEN "APAC"
  288. WHEN "Uganda" THEN "EMEA"
  289. WHEN "Ukraine" THEN "EMEA"
  290. WHEN "United Arab Emirates" THEN "EMEA"
  291. WHEN "United Kingdom" THEN "EMEA"
  292. WHEN "United States" THEN "US"
  293. WHEN "United States Minor Outlying Islands" THEN "US"
  294. WHEN "Uruguay" THEN "LATAM"
  295. WHEN "Uzbekistan" THEN "EMEA"
  296. WHEN "Vanuatu" THEN "APAC"
  297. WHEN "Vatican City State" THEN "EMEA"
  298. WHEN "Venezuela" THEN "LATAM"
  299. WHEN "Vietnam" THEN "APAC"
  300. WHEN "Viet Nam" THEN "APAC"
  301. WHEN "Virgin Islands, British" THEN "LATAM"
  302. WHEN "Virgin Islands, U.S." THEN "LATAM"
  303. WHEN "Virgin Is., U.S." THEN "LATAM"
  304. WHEN "Wallis and Futuna" THEN "APAC"
  305. WHEN "Western Sahara" THEN "EMEA"
  306. WHEN "Yemen" THEN "EMEA"
  307. WHEN "Zambia" THEN "EMEA"
  308. WHEN "Zimbabwe" THEN "EMEA"
  309. WHEN "Zimbabwe (Rhodesia)" THEN "EMEA"
  310. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement