Importing data with from SQL based on a date defined by existing .yxdb

[goatley1]

I have a data set that I'll be updating daily.  The original data set is maintained in SQL and updated in near real time.  For efficiency, I want to only import the new records, or the delta from the existing .yxdb to the current SQL status.  How can I grab a max date from the existing .yxdb and then leverage that as a variable to import transactions after that date from SQL?  In all other languages I would simply pass a variable that is defined by start_date = max(df.datefield).  I'm at a loss for how to pass this to the input tool.  Note: I'm a very new user with experience in Python, R, and other modified scripting languages.

[geraldo · Accepted solution]

hi.
Example:

1 read the .yxmd file - input data tool

2 summarize tool max date

3 configure dynamic input tool with 

dynamic input sql:

[goatley1]

Thanks,  for the swift reply.  This completely solved my problem.  Other posts on this topic were overly complicated.