Help

Join two Fields with formula and content control

Topic Labels: Formulas
Solved
Jump to Solution
449 2
cancel
Showing results for 
Search instead for 
Did you mean: 
margusveer
4 - Data Explorer
4 - Data Explorer

Hello!

How I can join two columns what I need Join with IF - example:

AreaCityLocation
HaljalaHaljalaHaljala
HiiumaaPaladeHiiumaa | Palade
MuhuMuhuMuhu
KullamaaKullamaaKullamaa
SaaremaaAsteSaaremaa | Aste

If the City and Area name are same then formula shows that name only one time
If City and Area names are different then formula shows two different names With space or some symbol between them

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hello, @margusveer ,

Try this formula

{Area} & IF({Area} = {City},""," | " & {City})

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

Hello, @margusveer ,

Try this formula

{Area} & IF({Area} = {City},""," | " & {City})

IF(Area=City, Area, CONCATENATE(Area, ” | “, City)

You can replace the “ | “ bit with another symbol.