3 Replies Latest reply on Jun 22, 2018 2:20 PM by Anushka A

    Changing data type in Tableau Prep

    Chris Broughton

      I have just started using Tableau Prep and think I have found a difference in how it processes data from an Excel file compared with Tableau.  My Excel file has columns with currency that, because there are also null and text values in some rows, are always set to text by both Tableau and Tableau Prep.  However, in Tableau I can change the data type to a number and all numerical values are retained.  In Tableau Prep the $ in front of the numbers appears to tag those as text so that changing the data type to number results in all null values.  Is there a reason for this difference?