why are a tableau data source and sheet showing different data

Question

I've created a Tableau workbook that is based off of a SQL query connecting to an Oracle Database. Let's pretend that the query has 2 fields, ID and Stock number. On the Data Source tab one row shows ID = 2040 and the Stock number = 47 but on Sheet 1, ID = 2040 shows a Stock number = 2040. The remote type of the Stock number field on the Data Source tab is "Fixed precision number" and on Sheet 1 it is "Double-precision floating-point number."

For a reason I do not understand the Stock number is equal to the ID for all rows of the data when looking at the data on Sheet 1 (or any other Sheet for that matter). This is incorrect when I look at the Data Source tab or if I use Oracle SQL Developer to run the query. Why and how is this happening in Tableau?

What I've already tried

• Using the Stock number field as a Dimension and a Measure
• Using "View Data" on Sheet 1 - It shows that the row where ID = 2040 also has a Stock number = 2040 instead of the correct value of 47

Answer 1

Let’s figure out the reason behind it, so this happens as with the use of select statement unnecessary and with the flow the complexity increases which ultimately make the tableau confused in terms of data types, so it’s better to check all the datatypes recommended by tableau and instead of using select statement just drag the table to the data source.

Want to be an expert in Tableau? Check out the Tableau Training to get the right assistance.