Hi,
I noticed and inconveniency, actually a problem, when reading a CSV with a column that contains only missing values. No number type can be selected.
In this scenario the numbers will be populated in a later iteration or, in other words, there is no guarantee that values are present upon initial interation. When concatenating with data from sub-sequent iterations, though, that causes a non-native data type.
Display of presence of number column
Column w/ missing values does not offer to select number types
General Fallback offers number types
I’d like to propose, only for the scenario where no data is actually present that limits the data-type choices, to always offer all types like for “any unknown new column”.
Best
Mike