Before you begin
-
You have previously added the dataset holding your source
data.
Download and extract the file: phone-users.zip. It contains a dataset with
user data including names, emails, US phones, etc.
-
You also have created the connection and the related dataset
that will hold the processed data.
Here, a Test dataset.
Procedure
-
Click Add
pipeline on the Pipelines page. Your new pipeline opens.
-
Give the pipeline a meaningful name.
Example
Format US user phone
numbers
-
Click ADD SOURCE to open
the panel allowing you to select your source data, here user data entered
manually as a test dataset.
Example
-
Select your dataset and click
Select in order to add it to the pipeline.
Rename it if needed.
-
Click and add a Phone processor to the pipeline. The
configuration panel opens.
-
Give a meaningful name to the processor.
Example
format US phone
numbers
-
In the Configuration area:
-
Select Format phone numbers in the Function
name list.
-
Select .phone in the Fields to
process list, as you want to format the phone fields.
-
Select Value in the Use with
list and American standard in the Region
code list as you want to format the user phones according to US
region codes.
-
Select National in the Format
type list as you want to format the phone numbers according to
standard local codes.
-
Click Save to
save your configuration.
Look at the preview of the processor to compare your data before and after
the formatting operation.
-
Click the ADD
DESTINATION item 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, the user phones have been updated according
to local US formatting and sent to the target system you have indicated.