The Sample tool allows you to select the First N Rows, Last N Rows, and Skip 1st N rows, but is there a way to use this tool to skip the last N number of rows?
I know that this can be accomplished by using Record ID, sorting and then skipping the first row, but I wasn’t sure if there was a more concise way.
The Sample tool is unable to accomplish this, but luckily there is a tool just for this built into the CReW Macros download. The tool is called “Skip Last N” and allows you to easily skip the chosen number of records.
This is the download for the CReW Macros: http://www.chaosreignswithin.com/p/macros.html
And here is some information on the Alteryx Community about it: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/CReW-Macro-Support/ta-p/465740.