Before you begin
-
You have previously created a connection to the system
storing your source data.
Here, an Amazon S3 connection.
-
You have previously added the dataset holding your source
data.
Download and extract the file: math-prices.zip. It contains a dataset with
data about the latest purchases of customers with pre-tax prices as well as the
tax amount to be included.
-
You also have created the connection and the related dataset
that will hold the processed data.
Here, a dataset stored in the same S3 bucket.
Procedure
-
Click Add
pipeline on the Pipelines page. Your new pipeline opens.
-
Give the pipeline a meaningful name.
Example
Calculate customer purchases including taxes
-
Click ADD SOURCE to open the panel allowing you to select your source data, here the last purchases of customers with tax information stored in Amazon S3.
-
Select your dataset and click
Select in order to add it to the pipeline.
Rename it if needed.
-
Click and add a Math processor to the pipeline. The
configuration panel opens.
-
Give a meaningful name to the processor.
Example
calculate price including tax
-
In the Configuration area:
-
Select Add, substract, multiply, and divide in the
Function name list as you want to add the tax amount
to the price of the purchase.
-
Select .latest_purchase_pre_tax in the
Fields to process list, as it corresponds to the
price of the last purchase without tax.
-
Enable the Create new column option to display the
result of the calculation in a new field.
-
Select + as the Operator as you
want to calculate the sum of two fields.
-
Select Other column in the Use
with list and .tax in the
Column list as you want to add the tax amount to the
original price.
-
Click Save to
save your configuration.
Look at the preview of the processor to compare your data before and after the
calculation operation. You can see that the type of the calculated data has
been automatically converted to number.
-
Click ADD DESTINATION and select the dataset that will hold
your output data.
Rename it if needed.
-
On the top toolbar of Talend Cloud Pipeline Designer,
click the Run button to open the panel allowing you to select
your run profile.
-
Select your run profile in the list (for more information, see Run profiles), then click Run to
run your pipeline.
Results
Your pipeline is being executed, a new field that contains the total amount of the last customer purchases including taxes is added to the original dataset and sent to the target system you have indicated.