4 Replies Latest reply on Jun 13, 2018 3:40 AM by Aditya Singh

    Joining SQL Server Data & Excel

    Sebastian Thierfelder

      Dear Tableaurians,

       

      I am trying to join a data table from a Microsoft SQL server with an Excel table (the sheet is neatly prepped for Tableau).

       

      Unfortunately I get the following message:

       

      SQL+Excel_Problems.PNG

      Just FYI, the SQL data table contains info on shipped orders by ZIP. The excel file contains transactions also on a ZIP level.
      My goal was to join them through this shared dimension.

       

      Any idea why this happens? I assumed that this join was in principle possible.

       

      Thanks in advance!!
      Seb