Summarize In-DB Tool

The Summarize In-DB tool summarizes data by grouping, summing, counting, counting distinct fields, and more. The output contains only the result of the calculations.

How to use this tool

  1. Drag a Summarize In-DB tool from the Tool Palette onto the workflow canvas.

  2. Connect another In-DB tool's output to the input of the Summarize In-DB tool.

  3. With the Summarize In-DB tool selected, configure the tool using the Properties window on the left.  

  4. Data fields from the input appear in the Fields section. Click to select the field to perform summaries on (Shift + click to select multiple fields to execute the same summary).

  5. With the field(s) selected, click the Add button.

  6. Make the selection and it will appear in the Actions section. Different summary functions are available depending on the type of data field selected.

  7. From the Actions section, you can select the field and use the up, down, and delete buttons to specify field order for the output.

  8. Rename a field by typing a new field name into the Output Field Name column.

  9. Properties: Additional properties need specification for certain actions. Actions with additional properties specification include: Concatenate Strings and Finance actions. See Summary Processes for more detail.

Output

The output contains only the result of the calculations.