Skip to main content Skip to complementary content

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.

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

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!