Top/Bottom

Contents[Hide]

The Top/Bottom transform is used to set up rules on how data should be sorted and how many records are to be returned (combination of Sort transform and Record Sampling transform without the random generation).

Transform - Top/Bottom
Transform - Top/Bottom

1. Input

The Top/Bottom transform requires 1 input transform that has at least 1 column.

The input could be a SQL Select transform, or the result of another transform. For example, we'll use the output of the Aggregate transform, as seen below:

Input Data: Sum of OrderQty Grouped by ProductID
Input Data: Sum of OrderQty Grouped by ProductID

2. Add the Transform

Steps to add the transform:

  1. Select the connector link.

    Adding the Top/Bottom transform - Step 1
    Adding the Top/Bottom transform - Step 1

    It is important to select the appropriate connector link. In this case, since the connector link on the right side of the Aggregate transform is selected, the Top/Bottom transform will be added after the aggregation is completed.

  2. Select the transform from the menu.

    Adding the Top/Bottom transform - Step 2
    Adding the Top/Bottom transform - Step 2

  3. To Edit/Configue the transform, select the newly added transform, and click the Configure menu.

    Adding the Top/Bottom transform - Step 3
    Adding the Top/Bottom transform - Step 3

3. Configure

Steps to configure the Top/Bottom transform:

For example, you just want to return the Top 5 products in terms of OrderQty.

Top/Bottom transform configuration dialog
Top/Bottom transform configuration dialog

  1. Enter the number of Record Count.
  2. Select the Starting Point. Available options are Top (default) and Bottom.
  3. Select the columns you want to be included in the output.
  4. Drag and Drop the column(s) you want to include in the sorting key.
  5. Select the sorting order, either Ascending (default) or Descending.

4. Output

The figure below illustrates the output from the Top/Bottom transform.

Top/Bottom - sample output
Top/Bottom - sample output

5. See also

Dundas Data Visualization, Inc.
500-250 Ferrand Drive
Toronto, ON, Canada
M3C 3G8

North America: 1.800.463.1492
International: 1.416.467.5100

Dundas Support Hours: 7am-6pm, ET, Mon-Fri