# Column Auto Type Cast: Add option to remove incompliant values

**URL:** <https://forum.knime.com/t/column-auto-type-cast-add-option-to-remove-incompliant-values/81808>\
**Category:** Feedback & Ideas\
**Tags:** feature-request\
**Created:** [August 3, 2024, 2:04pm UTC](https://forum.knime.com/t/column-auto-type-cast-add-option-to-remove-incompliant-values/81808 "2024-08-03T14:04:52Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![mwiegand](https://forum-cdn.knime.com/user_avatar/forum.knime.com/mwiegand/32/66896_2.png) [@mwiegand](https://forum.knime.com/u/mwiegand)\
**Post date:** [August 3, 2024, 2:04pm UTC](https://forum.knime.com/t/column-auto-type-cast-add-option-to-remove-incompliant-values/81808/1 "2024-08-03T14:04:53Z")

</div>

Hi,

I am working on a workflow to showcase various approaches to pivot without using a pivot node because the pivot node struggles to cope with large data set.

Using the Test Data Generator, which also creates outdated data, I encountered a situation where a value could not be converted to the identified data type.

`ERROR Column Auto Type Cast 3:1564 Execute failed: Can't convert 'URI: http://rsvimcfngtmtgtc; EXT: ' to URI. In Row0 Column29. Disable quickscan and try again.`

Using quick scan results in another issue

`ERROR Column Auto Type Cast 3:1564 Execute failed: Can't convert '2021-04-11T19:37:07.665' to Date and Time. In Row0 Column26. Disable quickscan and try again.`

**Proposal**  
I’d like to suggest to add an option to delete values (missing or empty) which are incompliant to the identified data type.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/c/f/cf4dff54d26b9ce511e404c3b5d959ad2d3bf6bc.png)

On that matter I also want to point out to another suggestion I once made:

> [@Column Auto Type Cast: Add option to fail or just warn on error](https://forum.knime.com/t/column-auto-type-cast-add-option-to-fail-or-just-warn-on-error/79942):
>
> Hi, while preparing an example workflow for knowledge sharing, trying to auto cast the type of aa table with unknown values, this error was thrown: ERROR Column Auto Type Cast 3:1623:0:1585 Execute failed: class org.knime.core.data.def.LongCell cannot be cast to class org.knime.core.data.StringValue (org.knime.core.data.def.LongCell and org.knime.core.data.StringValue are in unnamed module of loader org.eclipse.osgi.internal.loader.EquinoxClassLoader @de63949) I want to suggest to allow the C…

Best  
Mike
