-
1. Re: Field Length Workaround
Keshia Rose Jun 16, 2014 5:25 PM (in response to archie karas)Hmm, I don't know if there is a workaround for that, but there are other options for showing the list of countries. What is your end goal supposed to look like?
-
2. Re: Field Length Workaround
Tom WJun 17, 2014 4:55 AM (in response to Keshia Rose)
What's your datasource? I'm guessing Excel or Access. If so, there's a restriction on the amount of characters which can be displayed at one time.
As per Keshia's post though, I'm curious to understand what you're trying to achieve and why you're doing this!
-
3. Re: Field Length Workaround
archie karas Jun 17, 2014 11:16 AM (in response to Tom W)The goal is to have a list of all the countries grouped separated by commas, but to be able to filter on individual countries. However the field length truncates the grouped countries. The only way to have multiple values in one cell but filter them individually I have found has been to lay out the data in this way, create a calculated field ( if contains([BIGLIST],[INDIVID]) then [BIGLIST] end) and build a quick filter on the individual values.
The data sounce is Access, however my database does not connect to tableau. So I have been using Excel as my data source.
For reference the first problem was solved in this thread Custom Lists . I am still buggered on the second one however (field length).
-
4. Re: Field Length Workaround
Jonathan DrummeyJun 17, 2014 11:42 AM (in response to archie karas)
JET sources (Excel, Access, text files) are limited to 255 characters. This is a limitation of the database driver, not Tableau.
Tableau 8.2 has a new connector type for Excel and text files that supports more than 255 characters, I've tested it with memo fields with up to 10K characters. The new connector will do ODBC-pass-through, though, so you could either connect directly to Excel or indirectly to your Access database via Excel. When 8.2 is released (hopefully in the next couple of weeks) you could change your workbook to take advantage of the new connector by using the Replace Data Source functionality.
Jonathan
-
5. Re: Field Length Workaround
archie karas Jun 20, 2014 10:21 AM (in response to Jonathan Drummey)Yes, you are right. No need for a workaround, 8.2 does it perfectly. Thanks for letting me know, appreciate it!!
-
6. Re: Field Length Workaround
Jonathan DrummeyJun 30, 2014 10:20 AM (in response to archie karas)
You're welcome!