Filtering data

When data source is a database best way to filter data is to use where statement for files is filter expression

Click filter button to build filter expression

Basic Filter

Load data for specific customer

[RECORDTYPE]=1

Multiple criteria filter

([RECORDTYPE]=1) or ([RECORDTYPE]=56)

Add brackets for complex expressions