Skip to main content

Filtering and aggregating table columns directly on the DBMS

The following scenario creates a Job that opens a connection to a MySQL database and:

For more technologies supported by Talend, see Talend components.

  • populates a database table with the input data,

  • creates the output table for the filtered data,

  • instantiates the schema from a database table in part (for column filtering),

  • filters two columns in the same table to get only the data that meets two filtering conditions,

  • collects data from the filtered column(s), grouped by specific value(s) and writes aggregated data in a target database table.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!