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 ?
|
|
|
Powered by
FUDForum. Page generated in 0.02913 seconds