calculate the Order Year Sequence

[mdmukramali]

Dear All,

below is the sample data

LOAD * Inline

[

CUSTOMERID ,  YEAR

1 , 2006

1 , 2007

2 , 2007

2 , 2012

3 , 2007

4 , 2007

5 , 2007

7 , 2005

7 , 2007

7 , 2008

7 , 2011

7 , 2013

9 , 2003

9 , 2007

9 , 2012

10 , 2007

10 , 2011

10 , 2012

11 , 2007

18 , 2006

18 , 2007

18 , 2009

18 , 2012

18 , 2013

18 , 2015

18 , 2004

18  , 2003

]

;

looking for the Output like below.

each customer can make only one order per year.

CUSTOMERID = 1 make two order in 2007 and 2006.

so i need the last Sequence (YEAR)  in the first column and next Year of Order year in the next column so on.

attached the sample file also.

Thanks,

Mukram.

[swuehl · Accepted solution]

Maybe like attached?

[mdmukramali]

Thanks Stephen,

Perfect Solution.

Thanks,

Mukram