In Matillion, you can use the Filter component to filter rows in a data source based on a specific value in a column. Here are the steps to achieve this:
1. Add a data source component to your Matillion job.
2. Add a Filter component to the job after the data source component.
3. In the Filter component, select the column you want to filter on in the "Filter Rows By" section.
4. In the "Expression" field, enter the condition that specifies the desired value. For example, if you want to filter rows where the column "status" is equal to "completed", the expression would be `status = 'completed'`.
5. If you want to create a new output file with only the filtered rows, select the "Override Output" option and specify the desired filename and output location.
Here is an example of a Filter component configuration to filter rows with a specific value in the "status" column:
)
This configuration will output only the rows that meet the filter criteria to a new file. If you want to modify the existing data source, you can add a transformation component after the Filter component to make additional changes to the data.