Eclipse Community Forums Forum Search:

Home » Archived » BIRT » Can we use group by on combination of two rows?
Can we use group by on combination of two rows? Thu, 05 February 2015 20:01
 Nikhil MandaaraMessages: 13Registered: 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
 Michael WilliamsMessages: 1925Registered: 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
 Nikhil MandaaraMessages: 13Registered: 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
 Michael WilliamsMessages: 1925Registered: 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