Grouping of data
Posted: Tue Jul 23, 2019 9:25 pm
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
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