Prepare gems

Prepare gems clean, standardize, and structure datasets. Use these gems to transform data formats, remove duplicates, filter records, and prepare data for analysis.

Gems

Access the following gems from the Prepare category in the gem drawer.

DataCleansing

Standardize data formats

DataMasking

Obfuscate data in one or more columns

Deduplicate

Remove duplicates from your data

Filter

Filter the data

FindDuplicates

Return rows that match a certain count

FlattenSchema

Flatten nested columns

Limit

Limit the number of columns processed

MultiColumnRename

Rename multiple columns in your dataset in a systematic way

MultiColumnEdit

Change the data type of multiple columns at once

OrderBy

Sort the data

RecordID

Assign each row a unique ID

Reformat

Use expressions to reformat column names and values