Defining the maximum number of column for a dataset - 8.0

Talend Data Preparation User Guide

Version
8.0
Language
English (United States)
Product
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
Module
Talend Data Preparation
Content
Data Quality and Preparation > Cleansing data

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