Almost sure that's Daniel's issue - the second bullet point method - adding some dummy data - even one row is the easiest
1 of 1 people found this helpful
The maximum number precision allowed in Excel is 15 and your Id field has 18 digits, so Excel Jet is transforming the field to the default exponential format/truncating with '0's.( When precision exceeds 15, Excel specifications and limits - Excel - Office.com)
Workaround I suggest is to make the Id field as text and then put a single quote preceding the Id number.
Connect to the excel sheet from Tableau and create a new calculation 'New Id' to ignore the preceding single quote.
New id= Right([id],Len([id])-1)
Hope this will help you.
I have tested the same data in SQL server table and confirmed that there is no precision truncation with SQL driver and Tableau.So the above issue is caused by Excel JET precision control.
Thanks Shawn for pointing it out.
I just realized that in the above example, I have copied the excel data to Tableau so the single quote was preserved with the data. But when I connected to excel sheet directly Tableau automatically ignored the quotes.
Daniel: To clarify this, you don't need to create a calculation to remove the single quote, Tableau will automatically treat the Id as text and the quote will not be visible.