Use this method if you want to apply a condition to a table row and the operators and values in the basic condition builder meet your requirements. For example, for an Orders table, add a condition that the date in the ShippedDate column is greater than April 1, 2016.
Advanced Expression
Add filter conditions to tables with PowerCenter expressions. For example, for an Orders table, add the following expression:
(ShipCountry=’USA’) and ((ShipCity=’New York’) or (ShipCity=’Los Angeles’))
The filters use an AND logic. If multiple filters exist for a table,
Data Integration Hub
publishes only the rows that meet all of the conditions.