cancel
Showing results for 
Search instead for 
Did you mean: 

Drop first record

mongley
New Contributor II

Hi All,

I have a variable number of records coming from a mapper and will always want to drop the first. Is there an easy way to do this?

Thanks,
Mark

1 ACCEPTED SOLUTION

tstack
Former Employee

If you need to drop records, the Filter snap is usually a good option. In this case, you can use the snap.in.totalCount variable to get the total number of records that have been read by the snap. So, to skip the first one, you can use the following for the Filter Expression in the snap configuration:

snap.in.totalCount != 1

View solution in original post

6 REPLIES 6

tstack
Former Employee

If you need to drop records, the Filter snap is usually a good option. In this case, you can use the snap.in.totalCount variable to get the total number of records that have been read by the snap. So, to skip the first one, you can use the following for the Filter Expression in the snap configuration:

snap.in.totalCount != 1

mongley
New Contributor II

That’s nice thank you.