Open topic with navigation

Formatting Transformations

Formatting transformations enable you to apply transformations to attribute values, rows, column, tabs, and cells. The following formatting transformations are available and are defined in the sections below:

• Attribute Formatting Transformations
• Cell Formatting
• Row/Column Text Formatting
• Tab Formatting

Prerequisites

The instructions in the following subsections assume that you have already added the specified transformations 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.

Attribute Formatting

The Attribute Formatting transformation allows you to apply an attribute transformation to any selected attribute in the table. These transformations perform tasks on an attribute such as calculating or replacing a value, or applying a prefix or a suffix.

Example

The below column samples show how attribute values look before applying the transformation (left) and how they look after (right). The applied attribute transformation inserts the text 'Made of' before the attribute values for 'Material.'

Steps

1. After adding the transformation, under Parameters, click the ellipsis button (). The Attribute Formatting dialog displays.

2. Search or browse for the attribute to which you want to apply a transformation. Alternatively, click on the Legal Attributes tab to access the attributes that are linked locally to the product / classification node on which your table is built.

3. Click Add Transformation to launch the Select Transformation dialog. Select the relevant transformation, and then click OK.

The list of transformations is identical to those that are available when creating an attribute transformation in System Setup. For more information on the attribute transformations and what they do, see the Transformations topic in the Resource Materials online help here.

Three transformations to perform cell-level text transformations are also available within the list of transformations: 'Sort values within cells,' 'Range consolidation within cells,' and 'Remove duplicate values within cells.' For more information on these transformations, see the Cell Text Formatting Transformations topic in his guide here.

Cell Formatting

The Cell Formatting transformation allows you to narrow down formatting to individual cells in a table.

Example

This example uses two Cell Formatting transformations—one to change cells containing the word 'Blue' to have a light blue background and bold text, and the second to change cells containing the text 'Royal Blue' to a darker blue color, retaining the bold text applied in the first Cell Formatting transformation.

Steps

1. After adding the transformation, under Parameters, click the ellipsis button (). The Cell Formatting dialog displays.

2. In Search Expression, enter a regular expression to find specific cells. This option is case sensitive. For example:

• Enter the search expression 'Blue.' The value Blue is searched in the entire table and, if the value matches, the specified style will be applied to the cell.
• Enter the search expression as [A-Z]. The characters A to Z will be searched and, if any matches are found, the specified style will be applied to the cell.

For more information on regular expression and practical examples, see the Regular Expression topic in the Resource Materials online help here.

3. Check the Only for rows/columns box if you want the formatting to apply only for cells in specific rows or columns.

• Click the ellipsis button () to launch the Select Row/Column dialog. The options available in this dialog have already been explained in this topic in the Row/Column Text Formatting section above; refer to that section for more information.

4. In the Color to apply list, select the color you want to apply to the cells, or leave the default option of 'Do not change background color.'
5. In the Style to apply list, select the style that you want to apply to the cells, or leave the default option of 'Do not change text style.'
6. Click OK.

Row/Column Text Formatting

The Row/Column Text Formatting transformation enables you to transform data in specific columns or rows. You can calculate or replace values or apply prefixes and suffixes to values in entire columns and rows in one operation. Where the Attribute Formatting transformation is applied to a specific attribute, the Row/Column Text Formatting transformation enables you to transform data in columns and tables of your own choice.

1. After adding the transformation, under Parameters, click the ellipsis button (). The RowColumn Text Formatting dialog displays.

2. Select Ignore Headings if you want the transformation to ignore contents in header column types.
3. Click the ellipsis button () to launch the Select Row/Column dialog.

• Select Row or Column to specify whether the transformation applies to a row or a column.
• Select Attributes to apply the transformation to the column that contains the specified attribute. Click the ellipsis button () to search or browse for the relevant attribute.
• Select Product/Classification/Asset to apply the transformation to the column that contains the specified object. Click the ellipsis button () to search or browse for the relevant object.
• Select Heading to identify a column or row by typing the header text of the relevant column or row.
• Select Type to identify the column or row by selecting Column Type or Row Type.
• Select Number to identify the column or row by entering the sequence number of the relevant column or row. For example, if you want to apply the transformation the second column, then type 2.

• Select Group to apply the transformation to multiple columns. For more information, see the instructions provided for the Rule When Different transformation in the Layout Transformations topic here.

4. Click Add Transformation to launch the Select Transformation dialog.

The list of transformations is identical to those that are available when creating an attribute transformation in System Setup. For more information on the attribute transformations and what they do, see the Transformations topic in the Resource Materials online help here.

Three transformations to perform cell-level text transformations are also available within the list of transformations: 'Sort values within cells,' 'Range consolidation within cells,' and 'Remove duplicate values within cells.' For more information on these transformations, see the Cell Text Formatting Transformations topic in his guide here.

5. Select the relevant transformation, then click OK.

Tab Formatting

The Tab Formatting transformation inserts a tabulator in a row or column, which indents the text in the row or column with a tab.

Example

The below screenshot shows how a column looks before (left) and after (right) applying the transformation, which in this example inserts a tab before the values in the 'Color' column.

Steps

1. After adding the transformation, under Parameters, click the ellipsis button (). The Tab Formatting dialog displays.

2. Select Ignore Headings if you want the transformation to ignore contents in header column types or header row types.

3. Click the ellipsis button () to launch the Select Row/Column dialog. The options available in this dialog have already been explained in this topic in the Row/Column Text Formatting section above; refer to that section for more information.

4. Click OK.

2019, Stibo Systems – Confidential