Help - Change Column Type

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

Interested in our solutions? Please contact our sales team.

Whether you are new to data analytics or already an expert. We offer solutions for everyone. You don’t need to be a data expert to work with Spotzi Location. For more tailor made solutions we offer Spotzi Studio. With this plan you cannot only manage the data yourself but also connect to our API and manage users for the dashboards you create. Or work with our Market Ready Dashboards and drive on autopilot.