Help Center How To Use Our Products? Change column type

Change column 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:

  • String
  • Number
  • Date
  • Boolean

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.

Change Column Type

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.

Change Column Type

3. Confirm that you want to change the data type.

Change Column Type

4. Congratulations! Now you have changed the type of this particular column.

Change Column Type

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.

Related blog posts

Try Spotzi for free and start finding your best-fit customers