1 Reply Latest reply on Dec 8, 2017 6:20 PM by Yuriy Fal

    Tableau extracting incorrect data type?

    David Poustilnik

      Hi,

       

      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?

       

      Cheers,

       

      David