August 15, 2023

Filtering the salary records – Docs for ESB 6.x

  2. Talend for ESB Docs
  3. Docs 6.x
  4. Filtering the salary records – Docs for ESB 6.x

Filtering the salary records

  1. Double-click tMap to open the map
    editor.

    Note that the tHDFSInput component linked
    to this tMap has been configured along with
    the other tHDFSInput component linked to
    tAggregateRow.
    use_case-mr_tglobalvarload6.png

  2. From the table representing the input flow (on the left side), select all
    the three columns and drop them to the table representing the output flow
    (on the right side).
  3. On the table of the input flow, click the
    Expression_Filter.png button to display the filter
    expression panel.
  4. In this filter expression panel, enter
    row5.salary > Double.valueOf(String.valueOf(globalMap.get("avg")))

    This expression allows the tMap component
    to select only the salaries above the average calculated by tAggregateRow.
    Note that the row5 in this expression
    is the ID of the input row to the tMap
    component and therefore, it might be another value in your scenario.
  5. Click Apply and then OK to validate these changes.
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