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