Transform

Mammoth provides the following data preparation functions:

Label, Filter and Replace

These functions facilitate data filtering, labelling, or replacing:

• Apply Filter
• Find and Replace
• Bulk Replace
• Label & Insert text
• Show Top or Bottom Rows

Reshape, Group and Aggregate

These function facilitate data grouping, reshaping, aggregating, and so on:

• Group and Aggregate
• Columns To Rows
• Remove Duplicates
• Extract JSON
• Crosstab
• Concatenate Values

Column Functions

Column level tasks apply to one or more columns. These tasks do not change the number of rows and the affect of these tasks is limited to the data in one or more columns.

• New Column
• Remove Column
• Combine Columns
• Split into Multiple Columns
• Fill Missing Values with Grouping
• Copy Column Values
• Convert column type

Numeric Functions

These functions are exclusive to numeric datatype:

• Math
• Window Function
• Obtain Large or Small Values

Text Functions

These functions are exclusive to text datatype:

• Extract Text
• Text Formatting

Date Functions

These functions are exclusive to date datatype:

• Extract date part
• Date Difference
• Increment/Decrement Date Values