No it did not worked for me.
I tried changing the Data type from Number(Whole) to String to Float but none of them worked for me.
Is there another way to handle this?
There are several threads on the forums on this subject, and no consistently clear answer.
I'd be inclined to open a support case and see if you can get a clear response from Tableau.
And then, of course, post that response here for others to find!
Couple of questions for you, though.
1) What version of Tableau Desktop are you using?
2) What is the source of the data? Oracle, MySQL, ???
1 of 1 people found this helpful
Excel follows the IEEE specification of storing only 15 significant digits of precision. If you type any number in excel which is greater than 15 digits, it will round off the digits greater than 15 to 0. Check this link to explore further https://support.microsoft.com/en-us/help/78113/floating-point-arithmetic-may-give-inaccurate-results-in-excel
It seems like that Tableau is doing the same. Its doing some round off after 15 digits. This behavior is seen with Excel and Text files not with database like Oracle and SQL.
The only solution I can think of is storing the number in String format if you're not doing some arithmetic calculation with these numbers.
I will be opening a case with the support team.
Answers to your question are:
1. Tableau Desktop 2018.3.0
2. Source is Excel file in .xlsx
That's the same thing I also thought because of the Excel limitation it would have been rounding off to 0.So what I did was converted the number to text as those columns are not used for aggregation. But what I am surprised is that in Tableau the last 3 numbers are getting changed which can be seen in the highlighted part of the image present above.
I even converted the data type of columns to String in tableau but nothing happened.
Do not exactly know what is actually happening!
May be i'll have to raise a case with support.
Change the data type to Text in Excel not in Tableau and then import or you can append a apostrophe as a prefix in excel for these id numbers. Tableau then treat it as string and remove the apostrophe automatically.
Hi Ombir & Michael,
I have converted the data file to .csv and the values are coming correct also in Excel what I did was added a text at the beginning of the ID which Tableau as well as the Excel is considering it as text and both these solutions helped me.
This was a workaround but there should be a solution from Tableau's side as well.
Thanks to both for your help!