This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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.
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.