need help with a measure Issue

[Anika3186]

Hello,

I have a table with two columns ("City" and "country"). Now, I want to create a new column "Result". I'm looking for an expression that says:

If column country = "Other" and column City contains the word "Munich" then write "Germany", If country = "Other" and City contains the word "Cologne" then write "Germany" otherwise take on column "country".

Below is my expected output

City	country	Result
Munich and Dortmund	Other	Germany
Bremen and Cologne	Other	Germany
Berlin and Hamburg	Germany	Germany
London and Manchester	Other	Other
Rom and Florenz	Other	Other

Can somebody help me?

Thanks in advance!

Anika

[amitchandak · Accepted solution]

@Anika3186 , Create a new column result like

Switch ( True(),
[country] = "Other" && search("Munich",[City],,0) >0 , "Germany",
[country] = "Other" && search("Cologne",[City],,0) >0 , "Germany",
[country]
)

[littlemojopuppy]

Hi @Anika3186 

Try this...

IF(
	AND(
		[Country] = "Other",
		OR(
			NOT(ISBLANK(FIND("Munich", [City])),
			NOT(ISBLANK(FIND("Cologne", [City]))
		)
	),
	"Germany",
	[Country]
)