0

I'm trying to connect to a csv file locally on my computer, and I'm getting the following error message:

enter image description here

From previous experiences I've found out that, at least when connecting to xls/xlsx files, I get the "Error: 4: error generating sort key", when any string in my data set has a length of more than 255 characters. For this one however, the longest strings are 251 (I'm creating my dataset in R, and have a good overview and instant control of all string's lengths).

I've tried to minimize the length of all strings to 225 characters, and... it works. But, I want to maintain as much string length as possible plus I've never heard before that the limit should be lower than 255. Then I tried pushing it to 245 characters, and actually that worked too - i.e., it worked the first time around - second time I got the same error as before. Some times I get another error message instead, saying simply "String Comparison Error". I'm really confused about what's causing this. Starting to think it might not be entirely dependent on the string character length, but that there's something else to it as well.

What else could cause this error?

EDIT: I'm using Tableau 9.2.0 64 bit version

Morten Nielsen
  • 325
  • 2
  • 4
  • 19

1 Answers1

0

I know this is an old one, but I had the same issue, and like you I'm Danish (connection there).

My problem happens when one of my LT collegaues makes changes in the workbook, the only way to solve it is to change my regional settings to anything using . as decimal seperator and , as thousand seperator (ie. English UK).

Strange thing, once I've done it, I can change back, and keep using it on danish, but once I've restarted, same issue again.

In 9.3 is was Error generating sort key

In 10.2 it's string comparison error

Annoying error, that I really should report in detail, so they can fix it.

user2656595
  • 19
  • 4