How to skip transformation errors in the reformat component?

CloverDX Platform
1

How do I skip a transformation error in a Clover reformat component? I specified MIN_INT=CONTINUE; in the error action but that does not seem to be working. I am doing a str2date transformation and I would ideally like to skip any bad values before I insert this into the database. How can I achieve this?

Thanks

TAV

2

Hello,
it should work. Do you remember to return -1 from your transformation function if the string can’t be converted?

3

Currently I am getting a Clover exception (I am trying to do a str2date(date,‘yyyy-mm-dd-hh:mm:ss’), is there any way I can catch this and return -1? or if I set teh default return to -1 I will get a return of -1 when an exception occurs?

Thanks

TAV

4

Hello TAV,
catching exception is not possible in CTL. You can use is_date function, before converting or try_conver function instead of str2date. Another solution is to write your transformation in java.