This activity allows you to select rows from a table. To use this activity, you need to provide:
- An input table to select rows from
- Criteria for selecting rows
- Which columns you want to select
- How many rows to select
- (Optional) Sorting options
In the Select section of the activity’s properties, you configure all of these items. We’ll cover this section in two parts. This sample shows selecting rows from a table where their
3. For each matching row, all columns are being selected.
The next section is where we define how many rows to select and provide sorting options. In this sample, we’re selecting up to 5 rows and sorting by the
id column in ascending order:
See the Where Clauses page.
- If this activity isn’t letting you select the table you want, check that the activity creating the table has
Persist Tablechecked on its properties.
The following sample workflows are available in our repository’s workflows folder to help you get familiar with this activity. These can be imported using the instructions here or you can view the workflow in GitHub by clicking on it.