Add functions - 7.3

Talend Data Mapper User Guide

Version
7.3
Language
English
Product
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development > Designing Jobs
Last publication date
2023-01-05

Procedure

  1. Click the Total_Price element under the AC_Record element on the Output side to select it.
  2. In the Functions view on the left, expand the Arithmetic folder, and then drag the Multiply function and drop it onto the Value tab of the Total_Price element.
  3. Drag the Quantity element from under the C_Record element on the Input side and drop it into First Value - Drop/paste in the Multiply function on the Value tab.
  4. Drag the Unit_Price element from under the D_Record element on the Input side and drop it into Second Value - Drop/paste in the Multiply function on the Value tab, and then click Yes when asked if you want to change the output map element looping.
  5. Click the Type element under the AB_Record element on the Output side to select it.
  6. In the Functions view, expand the General folder, and then drag the Constant function and drop it onto the Value tab of the Type element.
  7. Double-click the Constant function in the Value tab, enter AB in the Value field of the Expression Constant Properties dialog box that opens, and then click OK.
  8. Click the Type element under the AC_Record element on the Output side to select it.
  9. In the Functions view, expand the General folder, and then drag the Constant function and drop it onto the Value tab of the Type element.
  10. Double-click the Constant function in the Value tab, enter AC in the Value field of the Expression Constant Properties dialog box that opens, and then click OK.
  11. Click the Type element under the AZ_Record element on the Output side to select it.
  12. In the Functions view, expand the General folder, and then drag the Constant function and drop it onto the Value tab of the Type element.
  13. Double-click the Constant function in the Value tab, enter AZ in the Value field of the Expression Constant Properties dialog box that opens, and then click OK.
  14. Click the Total_Value element under the AZ_Record element on the Output side to select it.
  15. In the Functions view, expand the Aggregate folder, and then drag the AgSum function and drop it onto the Value tab of the Total_Value element.
  16. Expand the Arithmetic folder, and then drag the Multiply function and drop it on the AgSum function.
  17. Click the AC_Record element on the Output side to select it.
  18. On the Loop tab, right click SimpleLoop and then click Copy.
  19. Return to the Total_Value element under the AZ_Record on the Output side and, on the Value tab, under the Multiply function, right-click Loop Expression - Drop/paste here, and then click Paste.
  20. Drag the Quantity element under the C_Record element on the Input side and drop it onto First Value - Drop/paste here, under the Multiply function on the Value tab.
  21. Drag the Unit_Price element under the D_Record element on the Input side and drop it onto Second Value - Drop/paste here, under the Multiply function on the Value tab.
  22. Press CTRL+S to save your changes.