community
cancel
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

Highlighted
Meteor

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!

Alteryx
Alteryx

You can do something like in the post below:

 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/get-the-data-with-latest-date/td-p/773...

 

But with the In-DB tools.

Alteryx Certified Partner

Hi,

 

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.

 

[]

Labels