I am using a "looped" workflow iterating over a number of csv-files to get one large file. Unfortunately the column types are changing for different files from integer to double. The files only contain numeric values. The file reader node faces that difficulty and stops working.
The workaround is to set the "difficult" columns to Double by default.
But unfortunatly this happens with different columns in different files.
Is there any possibilities to set at the very beginning all column types to "Double" so that any numeric value is seen as double value.
Hi Jürgen, I could only imagine that you read in the whole file whereby the data is read into a single column (using a fake column delimiter in the File Reader), and then split this data with the Cell Splitter node afterwards; double/int columns can then easily by converted into the most general type.
One option that may be worth exploring is manually casting everything to a double using a column list loop start but I expect this could be a bit slow and cumbersome to set up. If that sounds promising though, post back and I'll cook up an example.
