4 Replies Latest reply on Jun 22, 2018 1:03 PM by Allen Gradnigo

    Creating Join with TDE and Excel Shows Type Mismatch

    Jon Townsend

      This may have already been asked, but I couldn't find an answer that worked for my scenario.

       

      The scenario is that I have a Tableau Data Extract that has a field called "Customer Number" and I have an excel sheet which has the same field and I am trying to create a Left join between the two however the issue I am getting is "Type Mismatch between join fields [Extract].[Cust No](String) and [sheet1].[Cust No](Number(whole)).

       

      I have tried changing the data type of the field in the extract to be a number, did not work. I have also tried changing the data type in the excel sheet to text.

       

      Has anyone had this issue, and can you help me resolve it?

       

      Thank you.