You can concatenate (join) up to five columns and values in a single column. For example, if you were importing project data and wanted to create project name values using the customer name and the project code separated by a dash, you would set the fields as follows:
- Click the Data Manipulation
drop-down menu and select Concatenate. - In the Column field, select the column in which you want to concatenate columns and values.
- In the Value 1 field, do one of the following:
- In the first field, click and select the column you want to include in the concatenated value.
- In the second field, enter text you want to include in the concatenated value.
- In the first field, click
- Repeat step 3 to include other columns or text in the concatenated value.
- Click OK.