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?
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!
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).
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.
Yes, you are right. No need for a workaround, 8.2 does it perfectly. Thanks for letting me know, appreciate it!!