> For the complete documentation index, see [llms.txt](https://academy.carto.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://academy.carto.com/creating-workflows/workflow-templates/data-preparation.md). # Data Preparation ### Joining different datasets by a common column

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to join two tables based on a common ID on both tables. [**Download example**](https://storage.googleapis.com/carto-workflows-examples/files/join.sql)

### Join two datasets and group by a property

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

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**](https://storage.googleapis.com/carto-workflows-examples/files/join_and_group_by.sql)

### Union of two data sources with same schema

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

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**](https://storage.googleapis.com/carto-workflows-examples/files/union.sql)

### Filter rows using a custom geography

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to filter a data source using a custom geography input. [**Download example**](https://storage.googleapis.com/carto-workflows-examples/files/custom_geo_filter.sql)

### Generate a calculated column from a multi-column formula

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to generate a new column using a formula that involves different columns in the calculation. [**Download example**](https://storage.googleapis.com/carto-workflows-examples/files/multi-column_formula.sql)

### Normalize a variable to an index between 0 and 1

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to obtain a normalized index from a column in your dataset. [**Download example**](https://storage.googleapis.com/carto-workflows-examples/files/normalize.sql)

### Rank and limit a table

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

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**](https://storage.googleapis.com/carto-workflows-examples/files/rank_and_limit.sql)

### Filter columns

CARTO DW	BigQuery	Snowflake	Redshift	PostgreSQL	Snowflake	Redshift	PostgreSQL	CARTO DW
✅	✅	✅	✅	✅

This example demonstrates how to use Workflows to reduce a dataset to a smaller number of columns required for a specific analysis.. [**Download example**](https://storage.googleapis.com/carto-workflows-examples/files/filter_columns.sql)

--- # Agent Instructions This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com. ## Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter: ``` GET https://academy.carto.com/creating-workflows/workflow-templates/data-preparation.md?ask=&goal= ``` `ask` is the immediate question: it should be specific, self-contained, and written in natural language. `goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.