I have a table that gets refreshed daily (back up, drop and re-create), and is automatically refreshed within Tableau Server.
This process is not working because every time table is refreshed within Tableau Server, column values move to different columns.
Name , Dates
I am using Hive Database, and this has been a problem even within Hive; thus I had to create the table as a sequence file to avoid this situation.
And I can only refresh the data by adding a new data source, then replace the existing data source with newly added data.
Do you guys know any workaround for this? If you need more details, please let me know.
Is the underlying data source changing the actual fields on each drop/restore to something new/different? This sounds like an issue you would be best working with Tableau Support to reproduce and investigate further. Please open a ticket at https://support.tableau.com