I want to join on product column and limit it to those 200 products alone while joining. I feel just doing an inner join on the product column is inefficient. Please let me know how I can perform the join limit. Is it possible?
3 个回答
@AllenRajiv Masilamani - if the intent is to cross join SQL Server and Excel, then I'd recommend using PREP where you can perform the join and generate an extract for Tableau to read from.