Defining the maximum number of column for a dataset

Talend Data Preparation User Guide

author
Talend Documentation Team
EnrichVersion
6.4
2.1
EnrichProdName
Talend MDM Platform
Talend Real-Time Big Data Platform
Talend Data Services Platform
Talend Big Data
Talend Data Management Platform
Talend Data Fabric
Talend ESB
Talend Data Integration
Talend Big Data Platform
task
Data Quality and Preparation > Cleansing data
EnrichPlatform
Talend Data Preparation

To prevent the import of datasets with an abnormally large numbers of columns, a property can be added to the Talend Data Preparation configuration file to set a maximum number of columns to your datasets.

In other words, you cannot import a dataset with a number of columns exceeding the value set in the dataset.import.xls.size.column.max property of the <Data_Preparation_Path>/config/application.properties file. By default, this value is set to 1000.

This limit applies to all dataset types.

Procedure

To change this maximum number, add the dataset.import.xls.size.column.max property with the desired value.

For example: dataset.import.xls.size.column.max=50