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?
If you're on version 10.2+ you may want to try using
a Join Calculation with the INT( [Transactions_NUM] ) on both sides.