You can calculate the data for all operators of the feed definition and display the corresponding preview in a preview table. This enables you to track all data changes step by step.
The preview table provides several preview modes. For details, see the table below.
For performance reasons, the preview is limited to a maximum of 1000 rows by default.
Procedure
The feed data is calculated for the selected operator of the feed definition. The result is displayed in a preview table at the lower edge of the workspace.
The raw data preview (quick or full) of text-file operators (XML, JSON, CSV) is displayed in a single (non-sortable) column. The raw preview of an Excel operator has Excel column names (A, B, C, etc.) and an initial column that contains the line number.
Click once to change the sort order to ascending.
Click twice to change the sort order to descending.
Click three times to change the sort order to default.
The result is displayed according to your settings.
The preview mode remains selected as long as the data feed (or Assign data 1/2 dialog) is open.
The preview table provides the following preview modes.
Preview mode |
Description |
---|---|
Quick |
The selected operator returns at most 1000 rows in its result. This applies to the operator for which a preview is needed, as well as to all other operators required for calculating the preview. This preview mode is equal to the data preview provided in MashZone NextGen up to version 10.3. The Quick preview mode is preselected by default. |
Quick raw |
The preview displays the data of the source of the selected operator. This preview mode is supported only for the data source operators XML, JSON, CSV, and Excel. XML and JSON source data are reformatted with indentation. The results are limited to 1000 rows. |
Full |
The preview is displayed without limiting the operator results to 1000 rows. The actual limit depends on the license you use. |
Full raw |
The result of the raw data preview is displayed without limiting it to 1000 rows. The actual limit depends on the license you use. |
Statistics |
The result table has one line per measure, an initial column containing the name of the measure, and one column for each column of the operator's result table.
|