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

Last updated

Was this helpful?