fields always containing integer values get a sniffed type Integer.
fields always containing decimal values get a sniffed type Decimal with data formats properties decimal separator and thousands separator set accordingly.
If there are both fields with "." and "," as decimal separator, change one of them to Text by majority vote. In case counts are equal, prefer ".".
Goals:
Integer
.Decimal
with data formats propertiesdecimal separator
andthousands separator
set accordingly.Text
by majority vote. In case counts are equal, prefer ".".