Skip to main content
Use the Select component to choose which fields from the input will be available in the next component and transform them using expressions.
Select component in the pipeline designer
To select which fields will be available in the dataflow:
1
Add a Select component where required in your package.
2
Open the component and name it.
3
To automatically populate the fields section, click the Auto-fill fields icon. Otherwise, use the field dropdown and select the field you require.
4
Use the expression editor to manipulate field data using Integrate.io ETL’s expression language (see Using Expressions and Integrate.io ETL functions).
5
For each field row, assign an alias for your field in the right text box.
Assigning field aliases in the expression editor
6
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.
Reordering fields by dragging rows up or down

​
Field data types

The Fields list includes a Data type column that shows the type of each output field.
  • When a field passes through unchanged from a typed source (for example, a database source), the type appears as soon as you open the component.
  • Field-redefining transforms upstream (Select, Aggregate, Join, and similar) do not carry types forward. In that case, run a component preview to populate the column with the executed types from the preview response.
  • If no types are available, the column header shows an info hint. Run a preview to resolve the types.
Types are normalized to the Integrate.io vocabulary: String, Integer, Long, Float, Double, Binary, Boolean, DateTime, Map, and Bag.

Filter Transformation

Using Expressions

Functions Reference

Last modified on July 16, 2026