2021.1

Table Of Contents
Note
In a Text or PDF file, when you move the selection rectangle directly after extracting data,
you can use it to select data for the next extraction.
However, moving the selection rectangle that appears after clicking on a field in the Data
Model actually changes which data is extracted into that field.
CSV/XLS/XLSX file or database recordset
Tabular data is displayed in the Data Viewer in a table where multiple fields appear for each
line and row in the original data.
To select data, click on a field, keep the mouse button down, drag to the last field that you want
to select and release the mouse button. You cannot select multiple lines with tabular data.
Alternatively you can select fields just like files in the Windows Explorer: keep the Ctrl button
pressed down while clicking on fields to select or deselect them, or keep the Shift button
pressed down to select consecutive fields.
XML file
XML data is displayed as a tree view inside the Data Viewer.
In this tree view you can select nodes just like files in the Windows Explorer: keep the Ctrl key
pressed down while clicking on nodes to select or deselect them, or keep the Shift key pressed
down to select consecutive nodes.
You can select multiple fields even if those fields are in different nodes.
To get a better overview you can collapse any XML level.
XMLPath
The Goto step is rarely used in XML extraction workflows. The DataMapper moves through the
file using Xpath, a standard query language to identify and navigate nodes in an XML
document.
JSON file
JSON data is displayed as a tree view inside the Data Viewer. Arrays and objects are enclosed
in square or curly brackets, respectively: [] or {}.
Page 237