Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Alter Join data set Query Text
Alter Join data set Query Text [message #1769088] Wed, 26 July 2017 12:03
hariprassad arjunan is currently offline hariprassad arjunanFriend
Messages: 1
Registered: July 2017
Junior Member
Hi am new to BIRT I have below query.

I have one flatfile data source and other DB datasource.

I need to join above two dataset as below.

flate file data.
column1 column2
key1 aaa
key1 abb
key2 acc

DB query O/P :
dbcolumn1 dbcolumn2
key1 ooo
key2 jjj
key1 jsk


column1 column2 dbcolumn2
key1 aaa ooo
key1 abb jsk
key2 acc jjj

I used join dataset with inner join to achive this but getting duplicate rows as column1 values have many entry. To achive the above O/P i need to add distinct to the join query.

For join data set i cant see any queryText. How to achive this ?
Previous Topic:BIRT under Web
Next Topic:Null Pointer issue on BIRT 4.3.1
Goto Forum:

Current Time: Wed Oct 17 00:29:56 GMT 2018

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

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

Back to the top