3 Replies Latest reply on Jan 22, 2018 7:10 AM by Yuriy Fal

    Tableau extracting incorrect data type?

    David Poustilnik



      I'm extracting a data set  from an Oracle database with an attribute called "Transactions_NUM", it's a Number (22) whole in Oracle but it keeps on showing up as a Number Decimal in Tableau.


      On the other side I'm uploading an excel spreadsheet with the "Transactions_NUM". and I would like to join the "Transactions_NUM" to merge the data set, but in excel it's a string, hence I have changed it to a Number Decimal, but it keep on showing as a Number Whole.


      The joins states "Type mismatch between join fields [Oracle] as Number Decimal and [Excel] as Number Whole.



      Why is Tableau changing the database data type?


      How do I fix it?