BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: Upcoming Events: PGHBOUG: Nov 1.

Next Row Value


 
Search this topic... | Search DI: Designer and Job Design... | Search Box
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Author Message
BOBJFan
Principal Member
Principal Member



Joined: 24 Sep 2011

Posts: 138



PostPosted: Fri Aug 30, 2019 3:56 am 
Post subject: Next Row Value

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
Back to top
BOBJFan
Principal Member
Principal Member



Joined: 24 Sep 2011

Posts: 138



PostPosted: Mon Sep 02, 2019 5:29 am 
Post subject: Re: Next Row Value

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 !!
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Data Integrator -> DI: Designer and Job Design  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0267 seconds using 17 queries. (SQL 0.0027 Parse 0.0008 Other 0.0232)
CCBot/2.0 (https://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo