Learn

Clean and shape data

You clean data in Mammoth by adding tasks to a View's pipeline: an ordered list of steps that filter, fix, calculate, reshape and combine your rows. Click Describe your transformation (or the blue +) in any View to add one. Tasks re-run every time the data refreshes, so you build the steps once.

Changing how a column looks (its name, format, order or visibility) is a Display Change. It never alters the data or adds a task. See Rename, format and sort columns.

Fix and tidy values

I want to...	Go to
Keep or remove rows that match a condition	Filter rows
Fix spelling variants or replace text	Find and replace values
Label rows, fix single cells or fill blanks	Label rows, edit cells and fill blanks
Remove duplicates or check data quality	Remove duplicates and check data
Turn text into dates or numbers	Convert text to dates and numbers
Extract text, change case or read JSON	Work with text and JSON

Calculate and add columns

I want to...	Go to
Add, copy, combine, split or remove columns	Add, split, copy and delete columns
Calculate a number, a running total or a rank	Calculate with formulas
Shift dates, get a month or a financial year	Work with dates and financial years
Mark a column as an ID, a currency or a percentage	Column types, IDs, currency and percentages

Combine and reshape

I want to...	Go to
Join two datasets on a shared column	Join datasets
Look up one value, like VLOOKUP	Look up a value
Send cleaned rows to another dataset	Send to a dataset
Repeat rows for a list or a date range	Repeat rows
Summarise by group, pivot or unpivot	Group, pivot and unpivot

Use AI

I want to...	Go to
Describe a query in plain English	Write SQL with AI
Classify, enrich or translate values	Use AI on your columns

Run and control the pipeline

I want to...	Go to
See how tasks run, preview them, use Draft mode	How the pipeline works
Edit, suspend, reorder, copy or delete tasks	Edit, reorder and copy pipeline tasks
Select columns, copy cells, use the column menu	Work in the data grid
Colour cells or rows by a rule	Highlight values with colour
Hold a pipeline for approval or alert people	Pause a pipeline for approval with a Checkpoint
Hold dashboards and exports while you edit	Pause sends while you edit
Fix a task that shows an error	Fix a failing step

Looking for one function by name? See every function in the Transform menu.

Was this page helpful?

Something wrong? support@mammoth.io