August 15, 2023

Retrieving the filtered and aggregated data – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Retrieving the filtered and aggregated data – Docs for ESB 6.x

Retrieving the filtered and aggregated data

  1. In the design workspace, select tMysqlIntput
    and click the Component tab to define its basic
    settings.

    Use_Case_tCombinedSQLAggregate_16.png

  2. Select the check box Use an existing
    connection     ans choose tMysqlConnection_1 from the list.
  3. Click on the […] button.next to Edit schema to enter the following schema:

    Use_Case_tCombinedSQLAggregate_17.png

  4. In the field Table Name, enter
    empl_by_state and in the Query field, enter select * from
    empl_by_state    .
  5. In the design workspace, select tLogRow and
    click the Component tab to define its basic
    settings.

    Use_Case_tCombinedSQLAggregate_18.png

  6. Click the Sync columns button to retrieve the
    schema from the previous component and select the Table
    (print values in cells of a table)     mode.
Document get from Talend https://help.talend.com
Thank you for watching.
Docs 6.x
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x