Data Preparation

Joining different datasets by a common column

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to join two tables based on a common ID on both tables.

Download example

Join two datasets and group by a property

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL
✅	✅	✅	✅	✅

This example shows how to use Workflows to join two tables together and then group by a specific property, producing aggregated data coming from both sources.

Download example

Union of two data sources with same schema

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to generate a table that contains all the rows from two different sources with the same schema.

Download example

Filter rows using a custom geography

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to filter a data source using a custom geography input.

Download example

Generate a calculated column from a multi-column formula

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to generate a new column using a formula that involves different columns in the calculation.

Download example

Normalize a variable to an index between 0 and 1

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to obtain a normalized index from a column in your dataset.

Download example

Rank and limit a table

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to sort a table by a specific property, and only keep a certain number of rows.

Download example

Filter columns

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to reduce a dataset to a smaller number of columns required for a specific analysis..

Download example