I’ve got a workflow that imports a CSV file and a Excel file to Join them.
Column 21 (and some more columns) occur to have only numbers in them, but not all the time.
When this happens the CSV reader and Excel Reader node get an error
ERROR CSV Reader 0:117:105 Execute failed: The column ‘Column21’ can’t be converted to the configured data type ‘String’. Change the target type or uncheck the enforce types option to map it to a compatible type.
The column type in Excel is set to Standard so this shouldn’t bother the reader.
If I uncheck Enforce Type conversion in the reader nodes, the joiner node is in danger of failing as the types are no longer matching. And as the CSV Reader is inside a loop, the Loop End also fails
String type is fine for me if it would work.
How should I handle this instability in Import files?