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/ file. By default, this value is set to 1000.

This limit applies to all dataset types.


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 – let us know how we can improve!