Is it possible to Hide Red Text Exception in tFileInputExcel ?

[DavidETL]

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

[Anonymous · Accepted solution]

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.

[Anonymous]

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

[DavidETL]

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