Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Please help with simple incremental load

6 - Meteoroid

My input is a yxdb file. My output is a qvx file and a separate yxmd file with the max date of the data.


This max date of the data will be used as an input for the next time the workflow is run (the next day).


How am I able to filter the input the next day so that it uses the max date of the previous day as a filter for min date?
This will pick up all records from the yxdb which have been added since the previous run.


Any help appreciated!




Alteryx Certified Partner
Alteryx Certified Partner

Hi @Ns89 


Could you please share your workflow (at least a picture of it) with us?



8 - Asteroid

If your workflow is definitely ran EVERY day, you can use the formula below in your filter tool. The formula will get the current date and minuses one day from it. This returns yesterday's date.


[MaxDate] > DateTimeAdd(DatetimeToday(), -1, "days")


NB: I repeat, this will only work if you run the workflow every single day. If you skip a day, then you're going to filter out new records that shouldn't be filtered out.

6 - Meteoroid

Thanks @nerces - It doesn't seem like its possible to use a separate "custom" input as a filter.


I thought this quite basic functionality would exist but apparently not!


However, your solution would work in this case as I would run every day.