Skip to main content
Solved

Join two Fields with formula and content control

  • Jul 10, 2023 11:33 PM UTC
  • 2 replies
  • 64 views

Forum|alt.badge.img+1

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

Best answer by Sho

Hello, @margusveer ,

Try this formula

{Area} & IF({Area} = {City},""," | " & {City})
View original
This topic has been closed for replies.

2 replies

Forum|alt.badge.img+24
  • Inspiring
  • Answer
  • Jul 11, 2023 12:35 AM UTC

Hello, @margusveer ,

Try this formula

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

pressGO_design
Forum|alt.badge.img+22

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

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