Select from Table
Category: Table
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 id
equals 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:
Writing a Where Clause
See the Where Clauses page.
Hints
- If this activity isn’t letting you select the table you want, check that the activity creating the table has
Persist Table
checked on its properties.
Sample Workflows
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.