Cleansing data coming from a human resource management system - 7.1

Talend Data Preparation Quick Examples

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
Talend Data Preparation
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 in the left panel of this page.