Alteryx: How can I skip the last row of data in a workflow?

Question ID: 109379
2
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 (Questions: 7, Answers: 0)
Asked on February 28, 2020 4:18 pm
27 views
Answers
2
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 (Questions: 0, Answers: 7)
Answered on February 28, 2020 4:47 pm