This is my first post. Glad to be here.
I have a question on merging / union with 2 type of data source: MS SQL table & Excel
ShopInfo: (in MS SQL)
Sale:(in MS SQL)
Sale2: (in Excel)
What I hv tried:
1. Left join all the data source, but the "TotalPrice" from Sale and Sale2 would become two different fields, while the "Date" can't be synchronized too.
2. Create a calculated field applying both "TotalPrice" from Sale and Sale2, but Tableau shows that all the fields must be aggregate, and the "Date" can't be synchronized.
3. Try to union both Sale & Sale2 when doing the data connection and using the Custom SQL, but it fails while they are from different source type.
So, any alternative?
Thanks so much
Union won't work across datasources, you would need to pull your data into a single source for that.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...