How to skip additional in csv file if additional columns are not present in metadata

[abhinav5]

I have csv file in below format

ID|StringField|IntegerField|StringField1|DateField

1|test|1|test1|2021-02-12 12:11:50

2|test2|21|test21|2021-02-12 12:11:50

If file schema has changed and some columns are added in Between as below-

ID|StringField

|StringField2

|IntegerField|StringField1|DateField

1|test|test2|1|test1|2021-02-12 12:11:50

How we can skip StringField2 coulmn. Talend job throw below error-

Details: java.lang.NumberFormatException: For input string: "test"

[Prakhar1]

You should remove the column manually then.

If you want to read that column, then you can use dynamic schema which dynamically reads all the columns from file.

[abhinav5]

thanks for reply