-
1. Re: How to combine 2 Exel Tables into 1 with Tableau
Bora Beran Jun 24, 2015 1:37 AM (in response to phuviet.pham)1 of 1 people found this helpfulYou 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$]
-
2. Re: How to combine 2 Exel Tables into 1 with Tableau
phuviet.pham Jun 24, 2015 1:52 AM (in response to phuviet.pham)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
-
3. Re: How to combine 2 Exel Tables into 1 with Tableau
Hrvoje Gabelica Jun 24, 2015 1:56 AM (in response to phuviet.pham) -
4. Re: How to combine 2 Exel Tables into 1 with Tableau
phuviet.pham Jun 24, 2015 1:59 AM (in response to Hrvoje Gabelica)Thanks i got it
-
5. Re: How to combine 2 Exel Tables into 1 with Tableau
phuviet.pham Jun 24, 2015 2:20 AM (in response to phuviet.pham)Hi can anybody help me to correct this SQL:
i did it to Combine the 2 Tables but It alway give me error
-
test.twbx 8.1 KB
-
-
6. Re: How to combine 2 Exel Tables into 1 with Tableau
Jaideep Rokade Jun 24, 2015 2:39 AM (in response to phuviet.pham)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