1 of 3 people found this helpful
For your reference the following (Tableau version 9.3)
I "paste data" into Tableau & uploaded an exel with the following data
dimension measure 1 a TRUE b FALSE c d e TRUE f FALSE g
In both scenario my measure 1 column 1 is recognized as Boolean T/F without any further adjustment
3 of 3 people found this helpful
When Tableau determines a data type for each field, if the values in a field don't match that data type, Tableau handles the field in one of several different ways, depending on the data type. For example, sometimes Tableau populates those fields with Null values, as shown in the following table:
Mapped data type Treatment of other data types in the field. Text Dates and numbers are treated as text. Nulls are not created. Dates Text is treated as Null. A number is treated as the day in numeric order from 1/1/1900. Numbers Text is treated as Null. A date is treated as the number of days since 1/1/1900. Boolean Text, dates, and numbers are treated as Null.
If using fields that are based on mixed-value columns introduces difficulties when yanalyzing your data, you can do one of the following:
1.Format empty cells in your underlying data source so that they match the data type of the column.
2.Create a new column that does not contain the mixed values
Hi Norbert, thanks for your quick reply.
As it turns out I needn't worry; When viewing the columns in the data source view they were listed as Abc and couldn't be changed to Boolean, but once I jumped onto a sheet they were correctly labelled as Boolean on the sheet (which then updated the category in data source view)
So perhaps this is a rather innocuous bug?
Hi Tharashasank, thanks for your answer.
This is what stumped me. The column fields only contained True, False or null which shouldn't have given Tableau any trouble in reclassifying it as Boolean.
But anyway, problem solved by jumping into a sheet which also corrected the data source view.
I don't mean to resurrect a closed thread, but I am having a very similar issue with boolean values turning to null and the "answer" to this question does not apply to my situation, annoyingly.
I have a set of data very similar to the OP, but instead of TRUE, FALSE, my data is in the form of YES, NO, for example:
dimension measure 1 a Yes b No c d e Yes f No g
When I load this data in the Data view, it shows this dimension as text, but when I change it to Boolean, it turns the entire column into null values.
When I flip to the Sheet 1, as indicated as a possible solution by the posters above, I can "Describe" the field and see the boolean values:
However, when I drag the field into the view, it still displays nulls:
I am using Tableau 10.5.2 and the packaged workbook is attached.
Thanks in advance to anyone willing to look into this very annoying issue!
Book2.twbx 10.3 KB
I don't know if it is still helpful.
However, I figured out that the problem occurs if the source is an Excel.
It does not occur when the source file is a csv.
Hope my discovery is still helpful.
So the solution would be to export the Excel as csv.