> ## 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: Select Transformation

> Configure the Select transformation in Integrate.io ETL to choose, rename, reorder, and compute fields with expressions before passing data downstream.

<Frame>
  <iframe src="https://fast.wistia.com/embed/iframe/gbjesxraav" allowfullscreen playinline class="wistia_embed" width="640" height="360" />
</Frame>

Use the Select component to choose which fields from the input will be available in the next component and transform them using [expressions](/etl/using-expressions-in-integrateio-etl).

<Frame>
  <img src="https://mintcdn.com/integrateio/HSGmKiO3soPLENmi/images/creating-packages/using-components-select-transformation/image-1.png?fit=max&auto=format&n=HSGmKiO3soPLENmi&q=85&s=444b531469128b200e8318f89440ca28" alt="Select component in the pipeline designer" width="1200" height="828" data-path="images/creating-packages/using-components-select-transformation/image-1.png" />
</Frame>

**To select which fields will be available in the dataflow:**

<Steps>
  <Step>Add a Select component where required in your package.</Step>
  <Step>Open the component and name it.</Step>

  <Step>
    To automatically populate the fields section, click the Auto-fill fields
    icon. Otherwise, use the field drop-down and select the field you require.
  </Step>

  <Step>
    Use the expression editor to manipulate field data using Integrate.io ETL's
    expression language (see [Using
    Expressions](/etl/using-expressions-in-integrateio-etl) and [Integrate.io
    ETL functions](/etl/integrateio-etl-functions)).
  </Step>

  <Step>
    For each field row, assign an alias for your field in the right text box.

    <Frame>
      <img src="https://mintcdn.com/integrateio/HSGmKiO3soPLENmi/images/creating-packages/using-components-select-transformation/image-2.png?fit=max&auto=format&n=HSGmKiO3soPLENmi&q=85&s=2f9a97d7bea88d575d809b2c5d863d13" alt="Assigning field aliases in the expression editor" width="1200" height="828" data-path="images/creating-packages/using-components-select-transformation/image-2.png" />
    </Frame>
  </Step>

  <Step>
    To change the order in which these fields will appear in remaining dataflow
    components, click and drag the arrow located to the right of a field number
    up or down to the new position. If required, add rows for additional fields.

    <Frame>
      <img src="https://mintcdn.com/integrateio/HSGmKiO3soPLENmi/images/creating-packages/using-components-select-transformation/image-3.png?fit=max&auto=format&n=HSGmKiO3soPLENmi&q=85&s=979d4a6e3b81aed9ee936944e661f875" alt="Reordering fields by dragging rows up or down" width="1200" height="828" data-path="images/creating-packages/using-components-select-transformation/image-3.png" />
    </Frame>
  </Step>
</Steps>

## Related

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

  <Card title="Using Expressions" icon="arrow-right" href="/etl/using-expressions-in-integrateio-etl" horizontal />

  <Card title="Functions Reference" icon="arrow-right" href="/etl/integrateio-etl-functions" horizontal />
</CardGroup>
