Changing the calendar

Talend Data Preparation User Guide

author
Talend Documentation Team
EnrichVersion
6.4
2.1
EnrichProdName
Talend MDM Platform
Talend Real-Time Big Data Platform
Talend Data Services Platform
Talend Big Data
Talend Data Management Platform
Talend Data Fabric
Talend ESB
Talend Data Integration
Talend Big Data Platform
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

Talend Data Preparation allows you to easily switch from one type of calendar to the other with the Convert date function.

In this example, you are preparing some customer data that needs to be sent to one of your Japanese clients. Your dataset includes client information such as names, phone numbers, email addresses, but also the date on which they subscribed to a specific service.

You can see that in this dataset, the subscription dates have been entered using the dd/MM/yyyy format of the Gregorian calendar. Because the preparation is aimed at the Japanese market and you want to make it more adapted to this target, you will convert these dates to the Japanese calendar.

Procedure

  1. Click the header of the Subscription date column to select its content.
  2. In the Functions panel select Convert Date.

    The menu for the corresponding function opens.

  3. In the Source calendar drop-down list, select Gregorian calendar.
  4. In the Target calendar drop-down list, select Japanese calendar.
  5. Click Submit to apply the function on the column.

Results

The subscription dates are now using the Japanese calendar, while keeping the dd/MM/yyyy format, and you preparation is more adapted to your client.