Changing the calendar - Cloud

Talend Cloud Data Preparation User Guide

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
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.

    You have the possibility to output the result of this function in a new column by selecting the Create new column check box.

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.