Date functions in tDuplicateRow - 6.1

Talend Components Reference Guide

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 Open Studio for Big Data
Talend Open Studio for Data Integration
Talend Open Studio for Data Quality
Talend Open Studio for ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
Talend Studio
Data Governance
Data Quality and Preparation
Design and Development

The Function list for a Date column is date-specific. It allows you to decide the type of modification you want to do on date values.

There are three different ways to generate the date value for duplicated records:

  • Modify date value: randomly selects the day, month or year to modify and puts a random value in place.

  • Switch day month value: switches the day and month values. If the original day value is greater than 12, then the new month value will be ((N-1) mod 12) +1. For example: If the original day is equal to 13, then the new month is equal to 1.

  • Replace by random date: generates a random date with day, month and year values.