...
Option 1: Use a filter on the source table:
Step-by-step guide
- You have to use a correlated sub-query which means you have to specify the schema and fully qualify the table names. They syntax would be something like this:
TEST_DATE.UPDATE_DATE = (
select MAX(UPDATE_DATE) from SEMSTG.TEST_DATE where ID = TEST_DATE.ID
)- Set the Filter Type to Aggregate in the Properties of the filter (see screen shot above).
...
Option 2: Set a filter on the target table (this does not filter on the source)
Step-by-step guide
On the target field mapping, simply use the syntax: MAX(TEST_DATE.UPDATE_DATE) where update_date is replaced by your column name.
...
- Note there are some restrictions to using this method. For example, it cannot be used in conjunction with a Select Distinct. You will get an ORA error message which will highlight the incompatibility if there is one.
Related articles
Filter by label (Content by label) | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
...