Eclipse Community Forums: BIRT » Keeping sort order after joining two data sets.

Help

Home

Home » Archived » BIRT » Keeping sort order after joining two data sets.

Show: Today's Messages :: Show Polls :: Message Navigator

Keeping sort order after joining two data sets. [message #1385351]

Thu, 05 June 2014 18:54

Neil Wang

Messages: 105
Registered: July 2009

Senior Member

Hi,

Let's say I have two data sets.
The first data set is "Column" and it has two fields which are "Column Name" and "ID".
The second data set is "Attribute" and it has two fields which are "Attribute Name" and "ID".

I joined these two data sets by using the ID field. It looks like the result is sorted by "ID". Is it possible to keep the sort order based on "Column Name"? The "Column Name" field is not sorted alphabetically and I would like to keep the sort order that way.

Please advise.

Neil

Report message to a moderator

Re: Keeping sort order after joining two data sets. [message #1385361 is a reply to message #1385351]

Thu, 05 June 2014 19:51

Michael Williams

Messages: 1925
Registered: July 2009

Senior Member

In your "column" dataset, add a computed column that gives you a running count of your rows. After you've joined and the order has changed, you can use this row to sort the resulting dataset.

Michael

Developer Evangelist, Silanis

Report message to a moderator