Skip to main content

I am looking to normalise some Country data from different sources in different formats (e.g. some countries have full name others ISO codes). I have been using the ITEM() function to map all correct countries to our Master Country dimension.

I was now planning on doing something similar by pulling in the ISO code dimension which is also linked to the Country dimension. However, the ITEM() function does not seem to return any values which confuses me.
 


Ultimately, I am planning to then pull in the Country dimension from the ISO code and combine the two country fields via IF sentences. 

Hi ​@SHeckhuis hope all is well.

When using the ITEM() function it returns the item matching the value and  BLANK if none is found, in your case, it appears the ISO CODES are not being found, hence, blanks returned. 

Using the MATCH() function is designed to search for a value in a unique property of a Dimension List and return the first item that matches the value. You can use this function to match the ISO codes to the corresponding countries in their Master Country dimension.

Let us know if this helps or not. 

Thanks!

Hi ​@farhan13 ,

Thanks, that is what I thought, but as you can see from the screenshots, e.g. NO exists but yet nothing is showing up. I tried the MATCH() function and again, it doesn’t return anything. Maybe this is a support question.

Okay I found the issue. There is a space before each ISO code which I didn’t realise but meant there wasn’t a match. 

Reply


Ask your question here!

Terms & ConditionsCookie settings