Defining the maximum number of column for a dataset

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.