https://community.qlik.com/t5/Talend-Studio/How-to-skip-additional-in-csv-file-if-additional-columns-are-not/m-p/2326906#M96342 <P>thanks for reply</P> Fri, 19 Feb 2021 08:22:05 GMT abhinav5 2021-02-19T08:22:05Z https://community.qlik.com/t5/Talend-Studio/How-to-skip-additional-in-csv-file-if-additional-columns-are-not/m-p/2326904#M96340 <P>I have csv file in below format</P><P>ID|StringField|IntegerField|StringField1|DateField</P><P>1|test|1|test1|2021-02-12 12:11:50</P><P>2|test2|21|test21|2021-02-12 12:11:50</P><P></P><P></P><P>If file schema has changed and some columns are added in Between as below-</P><P>ID|StringField</P><P>|StringField2</P>|IntegerField|StringField1|DateField<P>1|test|test2|1|test1|2021-02-12 12:11:50</P><P></P><P></P><P>How we can skip StringField2 coulmn. Talend job throw below error-</P><P>Details: java.lang.NumberFormatException: For input string: "test"</P> Sat, 16 Nov 2024 00:34:39 GMT https://community.qlik.com/t5/Talend-Studio/How-to-skip-additional-in-csv-file-if-additional-columns-are-not/m-p/2326904#M96340 abhinav5 2024-11-16T00:34:39Z https://community.qlik.com/t5/Talend-Studio/How-to-skip-additional-in-csv-file-if-additional-columns-are-not/m-p/2326905#M96341 <P>You should remove the column manually then.</P><P>If you want to read that column, then you can use dynamic schema which dynamically reads all the columns from file.</P> Thu, 18 Feb 2021 13:51:54 GMT https://community.qlik.com/t5/Talend-Studio/How-to-skip-additional-in-csv-file-if-additional-columns-are-not/m-p/2326905#M96341 Prakhar1 2021-02-18T13:51:54Z https://community.qlik.com/t5/Talend-Studio/How-to-skip-additional-in-csv-file-if-additional-columns-are-not/m-p/2326906#M96342 <P>thanks for reply</P> Fri, 19 Feb 2021 08:22:05 GMT https://community.qlik.com/t5/Talend-Studio/How-to-skip-additional-in-csv-file-if-additional-columns-are-not/m-p/2326906#M96342 abhinav5 2021-02-19T08:22:05Z