2020.1

Boundaries
Boundaries are the division between records: they define where one record ends and the next
record begins; for an explanation see "Record boundaries" on page222.
CSV, Excel or Database file boundaries
Since database data sources are structured the same way as CSV and Excel files, the options
for these file types are identical.
l
Record limit: Defines how many records are displayed in the Data Viewer. This does not
affect output production; when generating output, this option is ignored. To disable the
limit, use the value 0 (zero).
l
Line limit: Defines the limit of detail lines in any detail table. This is useful for files with a
high number of detail lines, which in the DataMapper interface can slow down things.
This does not affect output production; when generating output, this option is ignored. To
disable the limit, use the value 0 (zero).
l
Trigger: Defines the type of rule that controls when a boundary is set, creating a new
record.
l
Record(s) per page: Defines a fixed number of lines in the file that go in each
record.
l
Records: The number of records (lines, rows) to put in each record.
l
On change: Defines a new record when a specific field (Field name) has a new
value.
l
Field name: Displays the fields in the top line. The boundaries are set on the
selected field name.
l
On script: Defines the boundaries using a custom JavaScript. For more information
see "Setting boundaries using JavaScript" on page373.
l
On field value: Sets a boundary on a specific field value.
l
Field name: Displays the fields in the top line. The value of the selected field
is compared with the Expression below to create a new boundary.
l
Expression: Enter the value or Regular Expression to compare the field
value to.
l
Use Regular Expression: Treats the Expression as a regular expression
instead of static text. For more information on using Regular Expressions
(regex), see the Regular-Expressions.info Tutorial.
Page 319