How to join columns together when importing

It is possible when using Zed Axis to merge two or more columns in your import file together and map to one field in QuickBooks by using a concatenate (join) function. For example you may have separate columns for the First Name (Tom) and Last Name (Jones) and you wanted to join those together to make a full name (ie Tom Jones).
 
 
Follow these steps below in Zed Axis to create a concatenate or join type function.
 
  1. Whilst creating or editing a map, opposite the field that you join, in the Function column select the option to <Add new function>
 
  1.  
  2. In the function editing screen enter the join expression for the fields that you would like to join together.  Details about how to create the expression are included below.
  3. Finally click OK and the Function will be saved and included in the map that you can use for this and subsequent imports.
 
Possible Syntax to use to create a join expression
 
Syntax Description Example
& Ampersand is used to identify a join {First Name}&{Last Name}
{ ....  } Curly brackets are used to enclose the name of the column to be joined {Last Name}
" ..." Parenthesis used to enclose text that is used to be inserted into the function, ie a space or a colon ":"
 
Example: To join the two columns together for First Name and Last Name and insert a space between the two.
 
{First Name}&" "&{Last Name}
 
 
 

Feedback

Add Feedback
As far as I can tell this doesn't actually work. The only thing that doesn't give, "Invalid Expression" in preview is using a single column name in {}
Keith (September 27 at 12:22 PM)

Add Feedback