How To Change The Data Type In Tableau

Tableau is the easy-to-apply Business Intelligence tool used in data visualization. Its unique feature is, to let information existent-time collaboration and data blending, etc. Through Tableau, users can connect databases, files, and other big data sources and can create a shareable dashboard through them. Tableau is mainly used past researchers, professionals, and government organizations for data assay and visualization.

In Tableau, we basically have 7 Data types as mentioned below:

String values
Number values
Engagement values
Engagement & Fourth dimension values
Boolean values
Geographic values
Cluster or mixed values

Normally, Tableau detects and allocate data types to all fields in a freshly uploaded data set. But, users have the equal right to modify the data types at many stages in Tableau.

Nosotros are going to discuss 3 major ways in which users tin modify the data types of existing information fields:

1. Changing data type of fields in the Data Source page:

In order to change the data type of field from the information source, the first step is to click on the field's data type icon. Equally a event, a drib-down list volition emerge, now choose a new data type and allot it to the values of that field.

In the above image, the data type of the 'User Id' field is 'Number (whole)'. Let's change its data type from Number to String.

It is conspicuously visible that the information type of the 'User Id' field is changed from Number to String.

2. Changing data type of field from Data pane:

Suppose the user doesn't want to disturb the data source but still wishes to change the data type of fields, and so in that location exists some other selection. The user tin easily alter the data types from the Data pane of Tableau. The first step is to click on the field'south information type icon. As a upshot, a drop-downwardly list will emerge, at present choose a new data blazon and apply information technology to the values of that field.

In the above image, the data blazon of field 'Proper noun' is 'String'. Let's modify it to Boolean.

It is clearly visible that the data type of the 'Name' field is changed from Cord to Boolean

3. Changing the information blazon of field in the View:

And, the last option to change the information blazon of fields is through Views. The first pace is to Correct-click the field and so choose Change Information Type from the driblet-down list. Now a new list volition exist opened, select a new data blazon and use it to the values of that field.