|Alter Join data set Query Text [message #1769088]
||Wed, 26 July 2017 12:03
| hariprassad arjunan
Registered: July 2017
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.
DB query 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.02332 seconds