Alteryx: How can I skip the last row of data in a workflow?
| ♥ 0 |
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. Thanks!
Marked as spam
|
Posted by |
Private answer
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. Hope that helps! Marked as spam
 Posted by Captain Tester (Questions: 0, Answers: 17) Answered on February 28, 2020 4:47 pm
|