Eclipse Community Forums: BIRT » Alter Join data set Query Text

Help

Home

Home » Archived » BIRT » Alter Join data set Query Text

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

Alter Join data set Query Text [message #1769088]

Wed, 26 July 2017 12:03

hariprassad arjunan

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

o/p

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 ?

Report message to a moderator

Previous Topic:	BIRT under Web
Next Topic:	Null Pointer issue on BIRT 4.3.1

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 19:40:49 GMT 2024

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter