Total rows of output is 130 million. i created as different hyper files for each year. Wanted to append the latest hyper file 2022 data to history. Is there anyway i can achieve this. At present i have created a workflow in Alteryx and publishing to Tableau server, which is taking 6 hrs. Is there any other way to achieve this? Any help is much appreciated.
Hi,
There are a few options I can think of:
1) Alteryx can read Hyper files and do a union there. I'd tend not to use this because given 130M rows there are alternatives.
2) Use the Hyper API (which can be called from Alteryx) to do the merge.
3) If the history file is already a published data source and you're updating it with the 2022 data then you can use one of the Update Data methods in the Tableau Server REST API. This would tend to be my preference.
