Tutorials

Combine two fields

Combine two fields

How to combine two fields

How to combine two fields

Written By: Marvin Hödlmoser

Last Updated on September 3, 2023

Combine two fields

Combine the address first line and second line

If you want only one address line column in your export - but you don't want to loose the second line information, you can combine the two columns:

  1. Select both fields

    Tip: Use the search field - like in this example "address" to find the fields you are looking for.


  2. Next add a Mapping with this setup:

Tip: Don't forget to click on "Add" or "Update"!

Explanation:

  • "If" checks if there is a second line present.

  • If yes - then the first line is updated by using these values:

    • {{ Shipping Address: Address first line }}

    • and {{ Shipping Address: Address second line }}

  • If we would only update the first line with the content of the second line, we would loose the information of the first line.

To fully understand the functionality please take a look at:

Set the value of a column using values of other columns and using math expressions