Skip to content

Get Size Activity

The Get Size activity retrieves the total number of rows within a specified dataset. This activity provides a quick method to determine the dimensions of your data for subsequent processing or validation.

Field Description Requirement
Dataset name The reference name of the dataset to be analyzed. Required
Size type The specific operation to be counted in the dataset (e.g., rows or columns). Optional
Result variable name The name of the variable where the returned count will be stored. Required

Action Types & Examples

Count Rows

  • Format: digit
  • Example Result: 100

Count Columns

  • Format: digit
  • Example Result: 5

Implementation Examples

Field Setup - Dataset name: newDS - Size type: Row - Result variable name: sizeResult

Execution Parameters - newDS (Dataset name) - Row (Size type) - sizeResult (Result variable name)

Technical Notes

The activity returns an integer representing the count. If the specified dataset is empty or the Size type cannot be determined, the activity returns 0.