I have SQL queries pulling datasets and appending them to a Tableau hyper file. I would like to have a workflow where it appends only data that's not already on the Tableau hyper file based on date, every time I execute it.
So far I have been using a join on the date field to compare the hyper file and the SQL output. However, this is inefficient as it pulls the whole dataset from the database. Is there a way to use the SQL query to pull only records where the date is not already present in the Tableau hyper file?
Thanks.
Solved! Go to Solution.
Get the hyper file and get the maximum date (or datetime, if needed). Then use the Dynamic Input in the Developers palette.
Connect it to the database , use a SQL statement in the SQL Editor. Then configure the Dynamic Input too l to replace a value in a where clause.