Hi everyone,
I have 2 Exel Table with the same Structure as the attachment. Now i want to Combine These Tables into 1 in Tableau like this Picture:
Can you please help me how to do that?. Thanks
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$]
union all
select * from [Sheet2$]
Hi Bora,
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
When you open your excel file, click on this button circled in red and click on Open with Legacy Connection. Custom SQL option would be enabled. Those two sheets should be in same excel file, not in separate files
Hi can anybody help me to correct this SQL:
i did it to Combine the 2 Tables but It alway give me error
Hello,
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
HTH!
Regards
Jaideep