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

    Cross Join error when combining SQL and excel data


      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


      Excel data: