Configuration in the tMap editor - 6.5

Palo

author
Talend Documentation Team
EnrichVersion
6.5
EnrichProdName
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 ESB
Talend Open Studio for MDM
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Business Intelligence components > Palo components
Data Quality and Preparation > Third-party systems > Business Intelligence components > Palo components
Design and Development > Third-party systems > Business Intelligence components > Palo components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click tMap to open its editor.
  2. On the Schema editor view on the lower part of the tMap editor, under the out1 table, click the plus button to add three rows.
  3. In the Column column of the out1 table, type in the new names for the three newly added rows. They are Year, Month, and Date. These rows are then added automatically into the out1 table on the upper part of the tMap editor.
  4. In the out1 table on the upper part of the tMap editor, click the Expression column in the Year row to locate the cursor.
  5. Press Ctrl+space to open the drop-down variable list.
  6. Double-click TalendDate.formatDate to select it from the list. The expression to get the date displays in the Year row under the Expression column. The expression is TalendDate.formatDate("yyyy-MM-dd HH:mm:ss",myDate).
  7. Replace the default expression with TalendDate.formatDate("yyyy",row1.random_date) .
  8. Do the same for the Month row and the Date row to add this default expression and to replace it with TalendDate.formatDate("MM",row1.random_date) for the Month row and with TalendDate.formatDate("dd-MM-yyyy", row1.random_date) for the Date row.
  9. Click OK to validate this modification and accept the propagation by clicking OK in the dialog box that pops up.