> ## Documentation Index
> Fetch the complete documentation index at: https://www.integrate.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# ETL: Transformations

> Transform data in Integrate.io ETL pipelines. Use 20 built-in components to filter, join, aggregate, sort, pivot, and reshape data.

Transformation components sit between your source and destination, letting you reshape data as it flows through the pipeline. Integrate.io ETL includes components for filtering rows, joining datasets, aggregating values, sorting, ranking, deduplication, pivoting, AI-powered transforms, and custom Python logic.

<CardGroup>
  <Card title="Select Transformation" icon="arrow-right" href="/etl/using-components-select-transformation" horizontal />

  <Card title="Filter Transformation" icon="arrow-right" href="/etl/using-components-filter-transformation" horizontal />

  <Card title="Join Transformation" icon="arrow-right" href="/etl/using-components-join-transformation" horizontal />

  <Card title="Cross Join Transformation" icon="arrow-right" href="/etl/using-components-cross-join-transformation" horizontal />

  <Card title="Union Transformation" icon="arrow-right" href="/etl/using-components-union-transformation" horizontal />

  <Card title="Aggregate Transformation" icon="arrow-right" href="/etl/using-components-aggregate-transformation" horizontal />

  <Card title="Distinct Transformation" icon="arrow-right" href="/etl/using-components-distinct-transformation" horizontal />

  <Card title="Sort Transformation" icon="arrow-right" href="/etl/using-components-sort-transformation" horizontal />

  <Card title="Rank Transformation" icon="arrow-right" href="/etl/using-components-rank-transformation" horizontal />

  <Card title="Window Transformation" icon="arrow-right" href="/etl/using-components-window-transformation" horizontal />

  <Card title="Limit Transformation" icon="arrow-right" href="/etl/using-components-limit-transformation" horizontal />

  <Card title="Sample Transformation" icon="arrow-right" href="/etl/using-components-sample-transformation" horizontal />

  <Card title="Clone Transformation" icon="arrow-right" href="/etl/using-components-clone-transformation" horizontal />

  <Card title="Assert Transformation" icon="arrow-right" href="/etl/using-components-assert-transformation" horizontal />

  <Card title="Cube Transformation" icon="arrow-right" href="/etl/using-components-cube-transformation" horizontal />

  <Card title="AI Transformation" icon="arrow-right" href="/etl/using-components-ai-transformation" horizontal />

  <Card title="Python Transformation" icon="arrow-right" href="/etl/using-components-python-transformation" horizontal />

  <Card title="Split Transformation" icon="arrow-right" href="/etl/using-components-split-transformation" horizontal />

  <Card title="Pivot Transformation" icon="arrow-right" href="/etl/using-components-pivot-transformation" horizontal />

  <Card title="Unpivot Transformation" icon="arrow-right" href="/etl/using-components-unpivot-transformation" horizontal />
</CardGroup>