Skip to main content

Transformations

Constitutes the set of Gems that help with transforming data

Transforms
Description
AggregateGroup data and apply aggregation functions such as avg or sum.
FilterSelect rows of data that meet a condition.
OrderByArrange the rows in a table or view in alphanumeric order based on the values of the specified data columns.
ReformatSelect columns, rename columns, or redefine existing columns from a table or view.
LimitLimit the number of rows in a table or view.
info

To learn more about the UI for Transformation Gems, see this page which illustrates features common to all Gems.

Run

When your Transformation Gem has the desired condition and expression, run interactively to view sample data.