When you say you want to union two "extracts", I assume you are talking about Tableau extracts (TDE or HYPER)?
Yes, I have two Tableau extracts (TDE) with same columns and I want to union those two.
I know that using the python extract API will convert the TDE format to hyper but tableau 10.5 knows how to read hyper so it doesn't matter to with which file i'll have in the end.
2 of 2 people found this helpful
In Tableau Desktop, in the top left "Data" pane, right click on your extract, then select "Extract", the "Append from File"
That should do it !
More information in the link below
Hi, Thank you for the response but I need an automated process (each day) and I don't want to do it manually.
I feel that this is more of a feature request then.
I found a similar idea here, which you can vote for :
Alternatively, you can post your own idea in the Ideas section, the more votes you get, the better chances you idea will have to be considered for a possible implementation.
There are two scenarios for union: 1.accumulation of data 2.analysis and comparison between 2 or more data sets.
There are automation solutions for both scenarios without extra tools:
1.using cumulative data extraction
2.case by case. If you tell me what specific analysis you want to do, what data sets are, etc. I can tell you what the tableau solution is.
I frequent less the forum these days. If you wish, contact me at alexandermou2000 at gmail.
Actually as of now, In Tableau Desktop Cross Database Union is not possible.
But you can use python extract API to read the data from both the sources and union them and then take the extract ie. to create a tde or .hyper file.
You can check EXTRACT API 2.0 in the Developer Options.
Hope this idea helps you in moving forward to the solution.
Using Tableau REST API and Tableau prep (Till 2019.2)
You can use Tableau Rest API to download the extract using "Download Data Source" method which will down the content in .tdsx format. Then you can unzip the file to get the extract. once you get the extract using Tableau Prep make union of both the extract.
Tableau Prep v 2019.3
In Tableau Prep v 2019.3 currently in beta . you can directly connect to extract from the Server , No need to download and make union of extracts and automate the extract using command line
Hope this answers your question