Transform gems
Access the following gems from the Transform category in the gem drawer.
📄️ Aggregate
Group and pivot your data
📄️ DynamicSelect
Dynamically filter columns of your dataset based on a set of conditions
📄️ FuzzyMatch
Match records that are not exactly identical
📄️ Pivot
Convert your table from long to wide format
📄️ Unpivot
Convert your table from wide to long format
📄️ WindowFunction
Create moving aggregations and transformation