Appending Data from Database Based on Latest Date

[HenryAlteryx]

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. 

[David-Carnes · Accepted solution]

@HenryAlteryx 

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.