Changing the calendar - 8.0

Talend Data Preparation User Guide

Version
8.0
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data
Last publication date
2024-03-26

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.

Note: You need a Java 11 environment to use this function to convert 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.