Remove first ten rows for specific Company name

[adombayeva]

Hi,

Could you please advise how to remove first 10 rows within 15 rows for each country name? Basically I need to remove 1-10 and leave 11-15 for UK, same way remove 16-25 for USA and leave 26-30; etc. There are more than 2000 records and more than 10 countries.

The data set  as follows:

Record #      Country 

1                   UK

..                   ...

5                   UK

...                  ...

10                UK

11                UK

12                UK

...                 ...

15                UK

16                USA

17                ...

...

25                USA

26                USA

...

30                USA

31                RUS

32                RUS

...

39                RUS

40                RUS

41                RUS

...

45                RUS

Thanks

[PeterA1 · Accepted solution]

Hey @adombayeva 

I think this can be accomplished by using a sample tool   And configuring it to "Skip First 'N' Rows" In this case "10 or 15, and then select "Group By: Country" In the box below.

This will skip the first N by country.

[adombayeva]

Hi @PeterA1 ,

Thank you very much, your solution worked!

I actually tried Last N rows, both are worked well.

Cheers

[adombayeva]

Hello @dondapati,

Many thanks, it works!

Have a nice week,

Cheers

[CharlieS]

Here's another solution that uses a Tile tool and allows you to set unique row filters by country. The only trouble here (and with the other solution) is if you have two UK countries in a row, so just something to think about.