I have a table where some sale prices are empty because the item wasn't sold. I think that in this case, it shouldn't force the column to string, but rather nullable numeric.
(I would also like to be able to explicitly set the column type to override the autodetected type, for situations like this, but issue #347 already exists.)
Sample data:
ID,Description,Sold,Sale Price
2501,Item 1.,FALSE,
2502,Item 2,TRUE,140.00
2503,Item 3,FALSE,
2504,Item 4,FALSE,
2505,Item 5,FALSE,
2506,Item 6,TRUE,70.00
2507,Item 7,TRUE,40.00
2508,Item 8,TRUE,35.00
I have a table where some sale prices are empty because the item wasn't sold. I think that in this case, it shouldn't force the column to string, but rather nullable numeric.
(I would also like to be able to explicitly set the column type to override the autodetected type, for situations like this, but issue #347 already exists.)
Sample data: