Hi all,
Tableau is treating Salesforce.com ID 18's as case-insensitive; however, in reality, they are.
So the following two leads, for example, are different leads in Salesforce.
00Q34000025nKLxEAM
00Q34000025nKLxEam
When I bring the field into the Rows section, Tableau treats them as one and counts them as one.
How can I tell Tableau not do so? Any help would be appreciated.
Kiavash,
I did the following test;
1- import a dimension with the two values. As you can see in the image, I have the same result than you, but in View Data, we can see that both values have been imported
keeping the case, it's just in the view that the case sensitivity is lost
2-now if I compute the ascii value of the last char, I get different values. Using this I am able to show both string in the view. Though I also have to make a calculation
with the Dim (simply concatenating and empty "").
3-Now if I create a new connection using the same datasource (in the example , I simply copy-paste and excel column), I see that now the Dimension is able to display both
values.
4-Now if I delete the first sheet and I close the first datasource, I can create new worksheets and Tableau has now become fully case sensitive.
So you can try this 4 steps as a workaround, but I suggest you contact Tableau Support regarding this, if you haven't already done. Because there is obviously a bug here.
Michel
