Cleansing data coming from a human resource management system - Cloud

Talend Cloud Data Preparation Quick Examples

Version
Cloud
Language
English (United States)
Product
Talend Cloud
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data
The HRMS Export dataset corresponds to an Excel file that has been exported from an American human resource management system (or HRMS).

It contains the full list of employees since the creation of the company with their name, job title, hiring date, departure date if any and bank information for their salary. In this dataset, the dates are in the American date format and you want to transform them to the French date format so that they can be used with French software solutions. Also, you want to extract the account number from the IBAN number for the French accounts.

Retrieve the HRMS_export.xlsx file from the Downloads tab of the documentation page.