Icon

81813 - Column Auto Type Cast Fails to convert unknown data type

Forum Topic

https://forum.knime.com/t/column-auto-type-cast-fails-to-properly-convert-unknown-data-type-but-succeeds-when-processing-string-type/81813

Issue

If the data type is unknown, the Column Auto Type Cast can fail to convert the data i.e.:

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.

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.

Mitigation

Convert unknown to string data type

Column Auto Type Cast
For Simplicity ascollections can causen-type issues
Collection to String
Make Flat
Unpivot
Sample Data
Test Data Generator
String Manipulation
Pivot
Fix Column Names from Pivot
Column Rename (Regex)
Column Auto Type Cast
Pivot
Fix Column Names from Pivot
Column Rename (Regex)

Nodes

Extensions

Links