Select top 10 rows

Ask a question
1

Hi,

Can’t seem to find how to do this as in SQL i.e SELECT top N.

I want to select the top 10 from a list of items sold. I have sorted them but can’t find the best way to select just the top 10.

Do I just number each row and filter rows lower than 11?

Cheers

2

Hey @JASON_MARTIN, yep I think you have it right – I would add row numbers using the Insert Row Numbers step then filter where row numbers ≤ 10.

2 Likes