Detecting Bad Values

Problem Description:

I am looking to detect bad values; I have set the input to read as text and in the preparation I have forced the values to decimal. I want to detect these values already with type validation (by isolating invalid decimals). ToD correctly recognizes these values in the visualization tab, but in the output, I get a file without these values.

Solution:

The values in red (so-called unrecognized values) are values stored separately because the Values column is of decimal type. The solution is therefore to change the type of the Values column to text just before the Bad_Data_KPI_D2 sink, which will bring the unrecognized values back into the Values column.