Set Analysis To Look at Data In Next Year

[dclark0699]

With this data:

PLAYERS:

LOAD * INLINE [

    playerID, HR, 2B, 3B, yearID

    bautijo02, 54, 35, 3, 2010

    bautijo02, 43, 24, 2, 2011

    beltrad01, 48, 32, 0, 2004

    beltrca01, 41, 38, 1, 2006

    berkmla01, 42, 35, 2, 2002

    berkmla01, 45, 29, 0, 2006

    bondsba01, 73, 32, 2, 2001

    bondsba01, 46, 31, 2, 2002

    bondsba01, 45, 22, 1, 2003

    bondsba01, 45, 27, 3, 2004

];

Is it possible to set up set analysis to return a list of players who hit at least 40 HR and then the following calendar year also hit at least 40 HR?

The expected results being

bautijo02

bondsba01

And then if that is possible, can you also say, within four years of hitting at least 40 HR, they hit at least 40 HR again?

The expected results  being

bautijo02

bondsba01

berkmla01

Thanks for any advice you can provide!

[dclark0699]

I'm really trying at all costs to avoid the load script, because in this case it's HRs, but I'd like to be dynamic enough to use on any column.

For example, the same solution would have to work on 2Bs and 3Bs without creating a flag column for all of them

[#3]

I do understand what you mean. The another way is to use functions like Above() in the expressions.

Like your expression can be yearID-above(yearID), but i am still trying to make it more dynamic and respect the input field values and HR bucket selection with this.

You can also try playing around with inter-record functions.

Thanks,

Singh