Concatenates the values in two columns, joins them by with string, and stores the resulting value in a new column.
<mergeColumns tableName="person"
column1Name="phoneAreaCode"
joinString="-"
column2Name="phoneSuffix"
finalColumnName="phone"
finalColumnType="varchar(50)"
/>
| tableName | Name table containing the columns to join [required] |
|---|---|
| schemaName | Name of the table schema |
| column1Name | Name column containing the first half of the data [required] |
| joinString | String to place include between the values from column1 and column2 (may be empty) [required] |
| column2Name | Name column containing the second half of the data [required] |
| finalColumnName | Name of the column to create [required] |
| finalColumnType | Datatype of the column to create [required] |
| MySQL | No Issues |
|---|---|
| PostgreSQL | No Issues |
| Oracle | No Issues |
| MS-SQL | No Issues |
| Sybase | No Issues |
| DB2 | No Issues |
| Derby | Not Supported |
| HSQL | No Issues |
| H2 | No Issues |
| Caché | No Issues |
| Firebird | No Issues |
| MaxDB | No Issues |
| SQLite | No Issues |
Automatic Rollback Support: NO