Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Can we use group by on combination of two rows?
Can we use group by on combination of two rows? [message #1602770] Thu, 05 February 2015 20:01 Go to next message
Nikhil Mandaara is currently offline Nikhil MandaaraFriend
Messages: 13
Registered: February 2015
Junior Member
In groups
Can we use group by on combination of two rows?
Re: Can we use group by on combination of two rows? [message #1602819 is a reply to message #1602770] Thu, 05 February 2015 20:45 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Combination of rows? or columns? If you mean by two column values, yes, there's an expression option for the group on value. If you mean row, could you explain a little more?

Michael

Developer Evangelist, Silanis
Re: Can we use group by on combination of two rows? [message #1602896 is a reply to message #1602819] Thu, 05 February 2015 21:55 Go to previous messageGo to next message
Nikhil Mandaara is currently offline Nikhil MandaaraFriend
Messages: 13
Registered: February 2015
Junior Member
Michael Williams wrote on Thu, 05 February 2015 20:45
Combination of rows? or columns? If you mean by two column values, yes, there's an expression option for the group on value. If you mean row, could you explain a little more?



sorry its column grouping.

What should i use between two columns? row["column1"]+row["column2"]
Re: Can we use group by on combination of two rows? [message #1602897 is a reply to message #1602896] Thu, 05 February 2015 21:58 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

Yeah. You'd just click the expression builder for the group value and enter whatever way makes sense to combine them. If it's possible that a combination of the two could be repeated improperly, say you have data like:

Column1 | Column2
A | AA
AA | A

what you're wanting to use wouldn't work, it'd be better to do something like: row["field1"] + "_" + row["field2"] or something like that.


Michael

Developer Evangelist, Silanis
Previous Topic:Can you help me? Myeclipse Birt Designer Error
Next Topic:Cannot call a function when creating a dataset
Goto Forum:
  


Current Time: Mon Jul 22 14:31:16 GMT 2024

Powered by FUDForum. Page generated in 0.04224 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top