| 31 | |
| 32 | Types of the columns represented in both example files: |
| 33 | |
| 34 | || '''Column headers in both example files''' || '''Value type''' || |
| 35 | || PATID || Integer || |
| 36 | || !PersonalNo || String || |
| 37 | || A030Sida_Beskrivning || String || |
| 38 | || A030Sida_Värde || Integer || |
| 39 | || KON_VALUE || Integer || |
| 40 | |
| 41 | Of the 5 columns with unknown type in the seconds example type (all data lines had blank cells for these columns), 3 could be identified as integer columns with high probability, based on other columns with the same header name suffix being of integer type. The remaining column could also be identified as integer with reasonable probability, based on other columns with the same header name prefix being of integer type. In conclusion, probably all the 5 columns with unknown type are integer columns. |