catching previous row.

[Nagaraj]

I have a requirement.

Code: Select all

skey(sorted)       col_a       col_b 
1                    1          3
2                    3          2
3                    2          3
4                    1          5

Output is 

Prev End_total
0       4(col_a+col_b)
4       9(previous End_total + col_a col_b)
9       14 (previous End_total + col_a col_b)
14     20 (previous End_total + col_a col_b)

Using Stage variables 

i am getting output as 

Prev End_total
0      4
4      5
5      5
5      6

I have used Getpreviousrowval() function to catch the prev values in the variables and substituted in 

sv1 > RowProcGetPreviousValue(curr_a + curr_b) (Prev)
sv1+ curr_a + curr_b > (End_total)

[chulett]

Please don't create polls here. The poll was basically: can this be accomplished? Yes/No/Maybe.

Can you be more specific about your question and/or issue? I don't really see what problem you are having from all that you posted. Where you say "Output is" do you actually mean "Output should be"?

[fmou]

Where you say "Output is" do you actually mean "Output should be"?

yeah, i believe so.

[chulett]

I believe so too but looking for the OP to confirm... and to be more precise with their language.

[Nagaraj]

output should be

Code: Select all

Prev End_total
0       4 (col_a+col_b)
4       9 (previous End_total + col_a col_b)
9      14 (previous End_total + col_a col_b)
14     20 (previous End_total + col_a col_b) 

[ray.wurlod]

So you're looking for a running, or cumulative, total. This is easily accomplished with stage variables. Many examples have already been posted on DSXchange.

[chulett]

Hmmm... I thought one of the "RowProc" routines (there are more than one) did running totals. Are those SDK routines officially documented in the supplied pdfs? (digs around) Ah, they are, found'em. Oddly enough, it is called RowProcRunningTotal.

As noted, this can also be done using properly ordered stage variables.