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
-
Click the Total_Price element under the
AC_Record element on the Output side to select it.
-
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.
-
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.
-
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.
-
Click the Type element under the AB_Record element on the Output side to select it.
-
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.
-
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.
-
Click the Type element under the AC_Record element on the Output side to select it.
-
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.
-
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.
-
Click the Type element under the AZ_Record element on the Output side to select it.
-
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.
-
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.
-
Click the Total_Value element under the
AZ_Record element on the Output side to select it.
-
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.
-
Expand the Arithmetic folder, and then drag
the Multiply function and drop it on the
AgSum function.
-
Click the AC_Record element on the Output side to select it.
-
On the Loop tab, right click SimpleLoop and then click Copy.
-
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.
-
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.
-
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.
-
Press CTRL+S to save your changes.