BusinessObjects Board

Next Row Value

dataservices job design
#1

Hi All,

Like Previous Row Value, how can we access next row value ? I could not find anything on similar lines.

for example here below, I need to access next row value;

col1 col2 from To
key1 - 111 - 20.10.2009 - 22.10.2009
key1 - 111 - 22.10.2009 - 25.10. 2009
key1 - 222 - 25.10.2009 - 01.01.5999

key2 - 666 - 19.10.2009 - 25.11.2009
key2 - 777 - 25.11.2009 - 01.01.5999

key3 - 444 - 12.11.2009 - 01.01.5999

So here I need to create column ‘To’ which picks up value under ‘From’ column in the next row as ‘To’ (highlighted 22.10.2009 for clarity, Also the last row of key1, Key2, Key3 I need to mark them as 01.01.5999.

thanks in advance, any help is much appreciated

BOBJFan (BOB member since 2011-09-24)

#2

Hi There,

Please help me achieve above result, I tried whatever I can think off but not able to get the results. I will be really grateful if someone can help me here. As BODS just work on 1 row at a time and no function to store next row value as we can do with previous_row_val function, I am not able to get the results as needed.

Appreciate any suggestions from the great team members here !!

BOBJFan (BOB member since 2011-09-24)