Hello. I created a SQL query that I want to add additional data from an excel file. I set up a primary (SQL) and secondary data source (excel sheet) set and I have a common ID linking them. If Bob in the SQL query has one sale > 10 and then has one sale < 5 in the excel sheet how to I set up my worksheet to see two rows for Bob? My column names match and the relationship is set. Thanks!!
Could you please attach two tables you are trying to connect?
Without seeing data structure, cannot provide appropriate answer.