Transform

Constitutes the set of Gems that help with transforming data.

📄️ Reformat

Select one or more columns or values using expressions and functions.

📄️ Filter

Filter your data based on a custom filter condition

📄️ Order By

Sort your data based on one or more Columns

📄️ Aggregate

Group data and apply aggregation methods or pivot operations

📄️ Flatten Schema

Flatten nested data

📄️ Schema Transform

Add, Edit, Rename or Drop Columns

📄️ Limit

Limit the number of rows

📄️ Deduplicate

Remove rows with duplicate values of specified columns

📄️ Set Operation

Union, Intersect and Difference

📄️ Window Function

Aggregate and transform Windowed data