DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
skumar
Participant



Joined: 25 May 2006
Posts: 88
Location: Hyderabad
Points: 839

Post Posted: Tue Jul 23, 2019 9:25 pm Reply with quote    Back to top    

DataStage® Release: 8x
Job Type: Parallel
OS: Unix
Hi All


I need help in resolving below example. grouping the data based on the keys(date ranges)

for Example

Before grouping data
A B C D E
100 200 1 1/1/2000 5/1/2001
100 200 1 5/2/2001 8/7/2005
100 200 3 8/8/2005 1/4/2007
100 200 3 1/5/2007 2/1/2008
100 200 1 2/2/2008 6/8/2010
100 200 9 6/9/2010 NULL

After Grouping data

A B C D E
100 200 1 1/1/2000 8/7/2005
100 200 3 8/8/2005 2/1/2008
100 200 1 2/2/2008 6/8/2010
100 200 9 6/9/2010 NULL


Is there any way or function in DS to create RANK when a key combination changes for these between dates.

please help.

Thanks
Kumar
ray.wurlod

Premium Poster
Participant

Group memberships:
Premium Members, Inner Circle, Australia Usergroup, Server to Parallel Transition Group

Joined: 23 Oct 2002
Posts: 54534
Location: Sydney, Australia
Points: 295710

Post Posted: Fri Jul 26, 2019 6:56 pm Reply with quote    Back to top    

Is this an exam question? I'm sure I've seen the requirement posted here previously. That said, there is always a solution, possibly more than one. For example, there is a function for dete ...

_________________
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours