Configuring the output component and executing the Job - 7.1

Text standardization

author
Talend Documentation Team
EnrichVersion
Cloud
7.1
EnrichProdName
Talend Big Data Platform
Talend Data Fabric
Talend Data Management Platform
Talend Data Services Platform
Talend MDM Platform
Talend Real-Time Big Data Platform
task
Data Governance > Third-party systems > Data Quality components > Standardization components > Text standardization components
Data Quality and Preparation > Third-party systems > Data Quality components > Standardization components > Text standardization components
Design and Development > Third-party systems > Data Quality components > Standardization components > Text standardization components
EnrichPlatform
Talend Studio

Procedure

  1. Double-click the tFileOutputExcel component to display the Basic settings view and define the component properties.
  2. Set the destination file name as well as the sheet name and then select the Define all columns auto size check box.
  3. Save your Job and press F6 to execute it.
    The tTransliterate component encodes input data to readable characters based on the repertoire of the Unicode Standard.
  4. Right-click the output component and select Data Viewer to display the transliterated data.
    All names written in characters from diverse languages have been phonetically converted to a standard set of characters based on the Universal Coded Character Set, UCS. For example, the names in the first and second rows in the below image have been changed to Ragnarr,Lodbrok and to Routse,Anna respectively.
    For further information about Unicode and Unicode Standards, check Unicode and Unicode Standard.