TableView Transform

image_pdfimage_print

With the TableView transform, data from a source can be filtered and sorted using regular expressions. General information on regular expressions can be found at http://en.wikipedia.org/wiki/Regular_expression. Any column can be filtered with the following operators:

equal

Only the specified elements are filtered. Example: Austria.

inAlphaRange

Alphanumerical values in a particular range are filtered. Examples include:

  • “[A100,A200]” – inclusive range: A100, A101, … A199, A200
  • “(A100,A200)” – exclusive range: A101, A102, … A198, A199
  • “[A100,]” – inclusive half-open interval : A100, A101, …
  • “[,A100)” – exclusive half-open interval: … A098, A099

inRange

Numerical values in a particular range are filtered. Examples include:

  • “[100,200]” – inclusive Range: 100, 101…..199, 200 
  • “(100,200)” – exclusive Range: 101, 102, … 198, 199 
  • “[100,]” – inclusive half-open interval: numbers greater or equal to 100
  • “[,100)” – exclusive half-open interval: numbers lower than 100

isEmpty

Empty values (blank, space, or multiple space values).

like

Filters the dimension elements according to regular expressions.

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

Main 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”.

Logical filter 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.

Example:
  • Data source:

Filter type “accept”:

  Result with logical filter operator “and”:

  Result with logical filter operator “or”:

Filter type “deny”:

  Result with logical filter operator “and”:

  Result with logical filter operator “or”:

Sorting

The columns of a data source can be sorted. Each sort field can be sorted in ascending (asc) or descending (desc) order. The sorting is processed BEFORE an eventual filtering of start and end rows.

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.

 

image_pdfimage_print
Was this post helpful?
NoYes (+2 rating, 2 votes)
Loading...