Yes you can load the multiple excel one after the one by clicking Add button next to connections and use the join function with common attribute to join those multiple sheets, Hope this answers your query.
The following may answer your question if the Excel sheets have the same fields.
If the Excel files are different please try the below:
thanks for the Response.
My main issue is I have many Excel Files having only one sheet in each File. The fields in the all files are same. But I want to merge them. If we use left join it will take all records from the first table and Common values in the second Table right. In this case the values which are not common will be excluded. if i load the data in the tableau Data Source, I haven't seen any option to merge the excel file tables.
Please help me for this issue.
Thanks in Advance
In the tableau version 10 its possible to load multiple excel files
Thank you for the response.