Hello,
I've created a new Data Connection to my MS SQL Server 2012 Database. I have a table that has 4 Columns:
When I connect to Tableau and look at these fields from this table I only show 3 Columns:
Why is my "Value" Column missing?
May 8, 2018 5:16 PM
I don't know this for sure, but my guess is that Tableau is unable to handle the sql_variant data type. Is there a specific reason you're using this data type? Could you try a different data type?
Unfortunately this Table is a part of an "out of box" database we use and can't change the field settings. This field is actually a user input field that stores values of custom fields we define. These Values are what we need to measure metrics on, but as you can see it's not coming through.
May 9, 2018 5:16 AM
Stephen, please take a look at the following: Support for SQL_Variant data type
The solution to this is to use custom SQL and cast the sql_variant to another data type. Your custom query would look something like this:
SELECT
IssueID,
FieldID,
CAST(Value as <target data type>) as Value,
OptionID
FROM dbo.hdCustomFieldValues
May 9, 2018 10:24 AM
Great!!
Hi Ken,
I have this same issue. What do I put in <target data type>? I want a string of text but NVARCHAR doesn't work.
Thanks
SELECT
IssueID,
FieldID,
CAST(Value as <target data type>) as Value,
OptionID
FROM dbo.hdCustomFieldValues
Apr 4, 2019 3:38 PM
Did you specify a length for your nvarchar? You'd need to do something like nvarchar(100)