Forum Discussion

reportuser's avatar
reportuser
Helper II
6 years ago
Solved

Combine multiple Address field columns from the same table

Hello, I have 4 address columns in the same table namely Address1, Address2, City, and zipcode. I need to merge it into 1 column, so far I have tried     Formula 1: Address = [Address1] & "," ...
General Comment
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    reportuser , Sorry my mistake not is missing

    Address = [Address1] & IF(not(ISBLANK([Address2])), "," & [Address2] ) & IF(not(ISBLANK([city])), "," & [city] ) & IF(not(ISBLANK([zipcode])), "," & [zipcode] )

amitchandak's avatar
amitchandak
Super User
6 years ago

reportuser , try like

Address = [Address1] & IF(ISBLANK([Address2]), "," & [Address2] ) & IF(ISBLANK([city]), "," & [city] ) & IF(ISBLANK([zipcode]), "," & [zipcode] )

  • reportuser's avatar
    reportuser
    Helper II
    6 years ago

    amitchandak- I'm sorry that did not work and you can find the output below

     

     

    Address = [Address1] & "," & [Address2] & "," & [city] & "," & [zip]

Output = Address1,Address2,city,zip

Address = [Address1] & IF(ISBLANK([Address2]), "," & [Address2] ) & IF(ISBLANK([city]), "," & [city] ) & IF(ISBLANK([zipcode]), "," & [zipcode] )

Output = Address1

     

    • amitchandak's avatar
      amitchandak
      Super User
      6 years ago

      reportuser , Sorry my mistake not is missing

      Address = [Address1] & IF(not(ISBLANK([Address2])), "," & [Address2] ) & IF(not(ISBLANK([city])), "," & [city] ) & IF(not(ISBLANK([zipcode])), "," & [zipcode] )