Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

In-Database Filter for Most Recent Date


Hi everyone,


I am new to using the In-DB functionality. My data set is a table that has millions of rows, and I only need to extract the rows with the most current date (I cannot use a today formula, as sometimes my latest data is from a few days ago).


Does anyone know how this can be accomplished? I am currently using the Filter In-DB tool, but just have no idea what the right formula would be.


Thank you in advance!


You can do something like in the post below:


But with the In-DB tools.

Alteryx Certified Partner



Build your sql statement by already ordering it in the order you want by ascending or descending dates. Put in the Connect in-Db or dynamic input in-db tool. In the filter I believe that you must have a date that will serve as a reference to filter the output data.