Page tree



Contents:

The cloud-based version of Trifacta Wrangler is now available! Read all about it, and register for your free account.

Generates the count of rows in the dataset. Generated value is of Integer type. 

NOTE: When added to a transform, the COUNT function calculates the number of rows displayed in the current sample and are not applied to the entire dataset until you run the job. If you change your sample or run the job, the computed values for this function are updated. Transforms that change the number of rows in subsequent recipe steps do not affect the value for the already computed instance of COUNT.

Basic Usage

count()

Output: Returns the count of records for the dataset.

Syntax

There are no arguments for this function.

You can use the group and limit parameters to specify the scope of the count. For more information on the group and limit parameters, see Pivot Transform.

Examples

Example - Simple row count

Source:

RowNum
Row 1
Row 2
Row 3
Row 4
Row 5

Transformation:

Transformation Name New formula
Parameter: Formula type Single row formula
Parameter: Formula count()
Parameter: New column name 'row_count'

sourcerow_count
Row 15
Row 25
Row 35
Row 45
Row 55

 

Your Rating: Results: 1 Star2 Star3 Star4 Star5 Star 13 rates

This page has no comments.