topic Re: Is it possible to Hide Red Text Exception in tFileInputExcel ? in Talend Studio

Is it possible to Hide Red Text Exception in tFileInputExcel ?

DavidETL — Fri, 17 May 2019 05:28:05 GMT

Hello,

Is there a way to hide/suppress the red text Exception produced by tFileInputExcel? I have some rows in a file which is a repeated header, and I basically want to hide the Red Exception that the component outputs as it provides warnings when it cannot convert a date etc.

Thanks in Advance

David

Re: Is it possible to Hide Red Text Exception in tFileInputExcel ?

Anonymous — Fri, 17 May 2019 12:01:19 GMT

If you have a situation where your data from a file cannot be trusted to conform to your expected schema, you should bring all column data in as Strings, then carry out type validation on the data before converting it to the expected type.

Re: Is it possible to Hide Red Text Exception in tFileInputExcel ?

Anonymous — Mon, 20 May 2019 15:31:40 GMT

You can configure the option "Die On Error" by activating the option or not

Re: Is it possible to Hide Red Text Exception in tFileInputExcel ?

DavidETL — Fri, 24 May 2019 02:20:53 GMT

Thank you, this ended up being the most robust solution.