Calculate the feed data

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

  1. Click the Calculate Calculate preview icon in the header of an operator.

    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.

  2. Select the preview mode in the corresponding drop-down menu in the header of the preview table.

    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.

  3. To change the sort order of a table, click a column heading.

    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.

  • Count: the count of non-NULL values for this column
  • #Null: the count of NULL values for this column
  • Min: the minimum value of this column
  • Max: the maximum value of this column
  • Avg: the average value of this column
  • Std: the standard deviation of this column
  • Unique: the number of unique values in this column
  • Top: a value that has the highest frequency
  • Freq: the frequency of the top value