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: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

need to assign one value per group

Goto page Previous  1, 2
 
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
jlynn73
Forum Associate
Forum Associate



Joined: 27 Oct 2009

Posts: 572
Location: DesMoines Iowa


flag
PostPosted: Wed Sep 04, 2019 7:58 am 
Post subject: Re: need to assign one value per group

If you reverse your sortation, previous row becomes next row. I did that in my spaghetti flow to get around storing the previous row into a global variable.

When you sequence your rows, you can access the next/previous rows by joining on the sequence +-1.
Back to top
BOBJFan
Principal Member
Principal Member



Joined: 24 Sep 2011

Posts: 139



PostPosted: Fri Sep 06, 2019 7:42 am 
Post subject: Re: need to assign one value per group

Ok, I will try that way, thanks!
Back to top
BOBJFan
Principal Member
Principal Member



Joined: 24 Sep 2011

Posts: 139



PostPosted: Tue Sep 10, 2019 5:45 am 
Post subject: Re: need to assign one value per group

Hi jylnn73,

I tried reverse sorting but then it is failing because for example if data is ;

subkey __ numkey __ valstart
aaa __ 111 __ 21.04.2019
aaa __ 222 __ 05.05.2019
aaa __ 111 __ 31.05.2019


then if I will reverse the sortation, I will get

subkey __ numkey __ valstart __ Valend
aaa __ 111 __ 21.04.2019 __ 31.05.2019
aaa __ 222 __ 05.05.2019 __ 05.05.2019
aaa __ 111 __ 31.05.2019 __ 21.04.2019


whereas my need is ;

subkey __ numkey __ valstart __ Valend
aaa __ 111 __ 21.04.2019 __ 05.05.2019
aaa __ 222 __ 05.05.2019 __ 31.05.2019
aaa __ 111 __ 31.05.2019 __ 01.01.5555

for the last row Valend will be 01.01.5555
Back to top
jlynn73
Forum Associate
Forum Associate



Joined: 27 Oct 2009

Posts: 572
Location: DesMoines Iowa


flag
PostPosted: Tue Sep 10, 2019 1:59 pm 
Post subject: Re: need to assign one value per group

That should work as long as you're sorting on the generated sequence number.

if your next date is always populated, you could always join on row number +1 for all except the last row.
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 2 of 2 All times are GMT - 5 Hours
Goto page Previous  1, 2
 
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.0325 seconds using 17 queries. (SQL 0.0081 Parse 0.0008 Other 0.0235)
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