In previous Tableau tutorial, we studied Tableau File types. Today, we will learn Tableau data types and different types of data types used in Tableau. This will help us to know Tableau software better and understand it better and easy to perform different tasks.
2. Introduction of Data Types
Scene information composes are ordered into one of the four classifications to be specific – String, Number, Boolean and date time. When information is stacked from source, scene naturally allocates the information writes, yet you can likewise change a portion of the information composes in the event that it fulfills the information transformation run the show. Additionally, the client needs to determine the information compose for ascertained fields. Before moving ahead let’s revise Tableau Navigation
3. Small Description of Tableau Data Types
a. String Data Types
Any arrangement of at least zero characters is known as string datatype in Tableau. We represent them but encasing them inside a single statement. They are encased in single statements. The statement itself can be incorporated into a string by composing it twice.
‘Quoted’ ‘quote’. They are further divided into – char and varchar2.
i. Char Data Type
Char data type in Tableau is used when we required settled length char. string. The biggest size of burn information compose is 2000 bytes. It can store alphanumeric esteems. Information ought to enter into single statements.
Note:- If the person enters an esteem shorter than the predetermined length then the database adds clear cushions to the settled length. In the event that, if the client enters an esteem bigger than the predefined length then the database would restore a mistake.
ii. Varchar2 Datatype
It stores alphanumeric esteems and backings a variable length character string. The biggest size of single information compose is 4000 bytes and involves just that space for which the information is provided. Information ought to enter into single statements.
Note:- Using varchar2 spares plate space when contrasted with scorch. A database would restore a blunder if the client enters an esteem bigger than the predefined length.
b. Number Data Types
These are either whole numbers (zero, positive and negative settled) or drifting focuses. It is better to round the drifting point numbers while utilizing them in counts. The general revelation is-number (P, S) where, P-it determines the exactness, i.e. the aggregate number of digits (1 to 38) and, S-it indicates the scale, i.e. the quantity of digits to one side of the decimal point, can go from – 84 to 127.
c. Boolean Data Types
They are logical values- TRUE and FALSE.
d. Date & DateTime Data Types
DATE & DATETIME store DATE and TIME information.
i. DATE Data Type
Default date arrange is “dd-mon-yy” or “dd-mon-yyyy”. Scene perceives dates in all configurations. Eg– “02/01/2015”. Be that as it may, in the event that we have to drive scene to perceive a string as a date then we need to put a # sign before the information like-“#3 March 1982”. It dispenses a settled length of 7 bytes each for a century, year, month, day, hour, moment and second. The date extend gave by a prophet is January 1, 4712 BC to December 31, 4712 AD.
ii. TIME data type
It is an extension of the DATE data type in Tableau. It stores the data in the form of century, year, month, date, hour, minute and second
4. Some Further Types of Tableau Data Type
a. Long Data Types
LONG Tableau data types, stores variable length, character strings and also extensive content strings. The biggest size is 2 GB. The memory accessible on the P.C. defines the access of length of long esteem.
Note:- A solitary table can contain just a single long section. No items can be returned on a long section. Long sections can’t show up in where provisos or in Integrity limitations. Records can’t be made on long segments. Long can be Returned through a capacity, yet not through a put-away method. Put away strategies can’t acknowledge long information as contentions.
b. Raw Tableau Data Types
Raw Tableau data types store parallel information like photographs, marks, thumb impressions and so forth. The biggest size is 2000 bytes. While utilizing this information, write the size because naturally, it doesn’t indicate any size. Just capacity and recovery of information are conceivable, controls of information are impossible. We can arrange the information in order.
i. Long Raw Tableau data type
It is also used to store binary data. The largest size is 2 GB. This data type cannot be indexed.
c. Large Object (LOB) Tableau Data Types
The inherent LOB information composes are a BLOB, CLOB, and BFILE. BLOB and CLOB stores information inside. The BFILE is LOB which stores the information remotely. The LOB information write can store huge and unstructured information like content, picture, sound, and video. The Maximum stockpiling size is up to 4 GB. BLOB stores unstructured double expansive items. CLOB stores single-byte and multibyte character information.
This Tableau Data types tutorial helps us understand the different data types used in Tableau and definitions better and thus help us work better with the technology. With this tutorial, we move a step further with our journey of mastering Tableau. We will wait for your valuable feedbacks.