Change column type
access_time 2 MIN | fiber_manual_record BEGINNER | label DATA, CHANGE COLUMN TYPE, CHANGE DATA TYPE
When importing a dataset into Spotzi every column has a specific type. The column type of every column can be found in the data view. The following types are distinguished:
These column types are quite important. Every type has its own SQL queries. At the same time some types don’t allow certain layer styling. For example, if you want to style your map layer based on range you can only use number column types. To change the column type you have to take the following steps:
1. Find your dataset. Click the OPTIONS button and select VIEW DATASET from the dropdown menu.
2. Click the arrow next to the data type. Now a drop down menu will appear. Select the data type you need. In this example we pick the numbers type.
3. Confirm that you want to change the data type.
4. Congratulations! Now you have changed the type of this particular column.
Keep in mind! Postal code data as a string type field
The most common mistake is made with postal codes. In some cases postal code datasets have a string (text) type instead of a number. This type doesn’t allow you to create a range map styling based on postal codes.