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 examplearrow-up-right

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 examplearrow-up-right

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 examplearrow-up-right

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 examplearrow-up-right

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 examplearrow-up-right

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 examplearrow-up-right

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 examplearrow-up-right

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 examplearrow-up-right

Last updated

Was this helpful?