1 of 1 people found this helpful
You can connect using Legacy Excel connection and write custom SQL to do UNION between the two tables.
It will look something like
select * from [Sheet1$]
select * from [Sheet2$]
Sorry but i am not familiar with Custom SQL. I tried it with Tableau 9 but i Count find Custom SQL Function. Can you please make one Example with the 2 Exel Data from me?. It would be very nice of you . Thanks
Thanks i got it
IF your data is same excel but on different sheets
use custom sql and apply UNION ALL function.
IF its in different excel
Create connection for 1st excel data.
create data extract for the same data
then use upend data from file
give the path of second excel data