2 Replies Latest reply on Nov 10, 2016 6:58 PM by Sherzodbek Ibragimov

    Cross Join error when combining SQL and excel data

    kere.eke

      Hi, I'm new to Tableau and I have come across a roadblock in performing a cross join between 2 data sources.  One source is from a SQL server and the other is from an excel spreadsheet.  In the custom SQL query, each username has about 10 rows of data corresponding to different weeks.  In the excel spreadsheet, for each row in the data, there is just one username per row (no repeats).  I am trying to combine the two based on username.SQL = username.Excel.   However, I keep receiving an error when I try to refresh the data.  I'm not sure if this has anything to do with trying to perform a cross join between different types of data sources.  Is there something I'm missing?  Any help would be much appreciated!

       

      Because the information is sensitive, I can't post the workbook here, but I've include a simplified form below.

       

      SQL data:

       

      usernameweeknumber of lessons
      user1133
      user1212
      user1374
      user21200

       

      Excel data:

      usernameSegment1Segment2Segment3
      user1Science1Traditional
      user2Humanities0Traditional
      user2Math1Nontraditional