Open topic with navigation

Merge Rows/Columns

The Merge Rows and Columns transformation enables you to merge two rows or two columns into one.

When you merge columns or row,s the values of both rows or columns are retained. After the merge, it will look as if two attributes are placed in the same column.

Prequisites

The instructions in this topic assume that you have already added the transformation to your table by following the instructions in the Add a Transformation to a Table or Table Type subsection of the Table Transformations topic here.

Example

In the following example, the Neck Style and Material columns are merged.

Before

Before the merge, the Neck Style and Material attributes are maintained in two separate columns.

After

After the merge, the contents of the two columns are now merged into one column. In this example, a hyphen is used as separator.

Steps

The Merge Rows and Columns transformation is set up in a three-step wizard.

1. After adding the transformation, under Parameters, click the ellipsis button (…). The Merge Rows/Columns wizard displays.

2. In the Orientation step, specify whether you want to merge columns or rows. Click Next.

3. In the Rows/Columns step, click the ellipsis buttons (…) to choose the rows or columns that you want to merge.

4. In the Result step, specify the row or column type to use for the merged column or row. In addition to the legal column / row types available to the table, you can also choose to keep the same style of the first merged column / row in the table.

• In this step, you can also specify a separator to be inserted between the attribute values of the merged columns or rows.

2. Click Finish.

2018, Stibo Systems