Home > Tools > Information Designer > Tips and Examples > Concatenating Strings

Concatenating Strings 

The Oracle SQL function CONCAT lets you create a column by concatenating strings from different tables.

Note: The following example only applies to data retrieved from an Oracle database.

• To combine strings from two different tables into a single column element:

1. Click New and select Column.

   Response: A Column Element tab is opened.

2. In the Data Sources tree, select the first column (Region in the example above).

3. Click Add >.

   Response: The selected element is added to the Source columns list on the Column Element tab.

4. Select the second column (State in the example above).

5. Click Add >.

6. In the Expression field, enter:
   
   concat ( concat (%1, ' '), %2)
    

7. Select String from the Data type drop-down list.

8. Type a suitable Description.

9. Click Save.

See also:

Creating a Column Element

Column Element Tab