Sample Tool - return only the 2nd row and not 2nd +

[DChaloult]

I am using this configuration for the Sample tool:

• "Skip 1st N rows" option.
• Set the value of N to 1.

In this scenario, I have a list of 3 files, I am expecting the 2nd row "...11-20-24.xlsx" to return

However, I get back rows 2 and 3 after the first row is skipped. 

My workaround is to add another Sample tool after that to then select the first row.

QUESTIONS:

• Why is the Skip 1st N rows returning two rows (or really all files after the first row)?
• Can I do this all with one tool? Is there a better way to get the 2nd row without having to add another tool?

Thank you

[alexnajm · Accepted solution]

Use a Select Records tool and just grab "2"!

[alexnajm · Accepted solution]

 Select Records Tool

[DChaloult]

That's so much better than the sample tool! Thank you

[alexnajm]

Happy to help