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.
On that matter I also want to point out to another suggestion I once made:
Best
Mike