TableView Transform
With the TableView transform, data from a source can be filtered and sorted. Sorting behavior depends on the value type of the sorted column. See more in the Sorting section below.
Any column can be filtered with the following operators. The values for each expression depend on the operator used; specific values are noted when necessary in the descriptions below.
equal | Only the specified elements are filtered. Example: Austria. |
inAlpharange | Alphanumerical values in a particular range are filtered. Examples include:
|
inrange | Numerical values in a particular range are filtered. Examples include:
|
isEmpty | Empty values (blank, space, or multiple space values). For this operator, the Value field should be left blank. |
isNull | The condition is true for NULL values but not for (possibly trimmed) empty strings. |
like | Filters the dimension elements according to regular expressions. General information on regular expressions can be found here. |
Examples:
Expression | Result |
Jan|Feb|Mar | Jan, Feb, or Mar |
^KS | All values starting with KS |
_00$ | All values ending with _00 |
^$ | Only empty values |
Inputname | Filter Type | Operator | Value |
Date | accept | equal | 2009 |
The settings for the TableView transform are described below:
Filter type: various filter lines to the same input column are evaluated like a rule chain with the filter types "accept" and "deny". If only accept-filters are used this behaves like a logical OR.
Logical operator: here you can define the logical operator between the filtering lines. This is only relevant if there are several filter lines with different input columns.
and: a data record is in the filter result when it matches the conditions of all filtered columns.
or: a data record is in the filter result when it matches the conditions of at least one filtered column.
The logical filter operator "and" is the default.
Example:
Data source | ||
Filter type “accept” |
|
|
Result with logical operator “and” |
|
|
Result with logical operator “or” |
|
|
Filter type “deny” | ||
Result with logical operator “and” | ||
Result with logical operator “or” |
Sorting
The columns of a data source can be sorted. Elements can be sorted in ascending or descending order, with or without case sensitivity. The sorting is processed BEFORE an eventual filtering of start and end rows.
Note that sorting is numerical only when the sorted column has number sequences as value type, e.g. double / integer numbers; otherwise, the default behavior is alphanumeric order, that is, a lexical / string-based sorting. For example:
-
Lexical sorting: 12 < 5 < 5.0 < 6
-
Numerical sorting: 5 < 6 < 12
Filtering of start and end rows
The first and the last rows of the data source can be filtered with these options:
Start line | The result starts in the source row with this index. Previous rows are filtered out. If not set, all rows are taken from the beginning. |
End line | The result ends in the source row with this index. Subsequent rows are filtered out. If not set, all rows are taken up to the end. |
Note: when the input is coming dynamically from the Source or Transform, but the "Field name" is left empty, the name of the source column/ function is used for the Field name. When the target is manually defined as constant, then the name "constant" is chosen instead of the value from the "Input" field. Adding more than one constant column results in error, because there would be two columns with the name "constant."
Updated September 27, 2024