The Suppress Rows/Columns transformation suppresses rows or columns based on specified matching criteria or whether all values in a specified row or column are equal or non-equal. For example, rows or columns can be suppressed if:
In the case of equal values, this transformation may be useful for rendered tables that have retrieved values using the 'Attribute Group Attributes' content definition. In some cases, these values will be the same for all the rendered products. This transformation enables these rows / columns to be suppressed if the values are equal.
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.
In the following example, any rows that contain the Color value of Kelly Green will be suppressed. A sample use case could be that this color is only available for spring, but the summer catalog is about to publish. So, shirts of this color will be suppressed in the table so they do not appear in the summer catalog. They can be unsuppressed later for next spring's catalog.
Before
This is how the table appears before the suppression of the Kelly Green shirt rows.
After
This is how the table appears after. The Kelly Green T-Shirts no longer appear.
The following example uses an extremely basic regular expression that suppresses rows by matching on a single character. For more detailed information about regular expressions, see the Regular Expression section of the Resource Materials online help here.
Before applying the transformation, the table is very tall and contains what appear to be duplicate products, which have an underscore and number at the end of their STEP Names, e.g., Christmas Party Hat_2, Christmas Party Hat_3, and so forth.
To suppress all rows that contain these products, the Column 'STEP Name' is chosen for Column; the 'is' radio button is selected; an underscore character is entered into the text field; and 'regular expression' is checked.
After applying the transformation, the table looks like this. All rows are removed where the STEP Name value contained an underscore.
). The Suppress Rows/Columns dialog displays.
) in the Column or Row field to display the Select Row/Column dialog. Select Row to suppress rows and Column to select columns. The options available in this dialog have already been explained in the Row/Column Text Formatting section of the Formatting Transformations topic (here); refer to that topic for more information.
2019, Stibo Systems – Confidential