Actions on preparation columns - 7.3

Talend Data Preparation User Guide

author
Talend Documentation Team
EnrichVersion
7.3
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 Real-Time Big Data Platform
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

In a column header, click the menu icon next to the column name to display the available options.

The table below describes the different actions that you can perform on columns.

Action Description
This column is a... Allows you to change a column data type, if the value is not the desired one.
Create column Creates a new column to include additional data in your dataset if needed. Specify a name and how to fill the content of the new column, either by copying an existing column, generating a sequence of integers, or leaving it blank.
Delete column Allows you to remove unnecessary columns.
Duplicate column Creates a copy of a given column.
Rename column You can rename a column with a meaningful name if you want to identify them more easily.

It is also possible to rename a column by double clicking its name.

Display rows with valid values

Display rows with invalid values

Display rows with empty values

Display rows with invalid or empty values

Allows you to directly apply a filter on a certain category of data for a given column, even if there is no matching value in the sample. This can be useful when working on a large dataset for example.