on 06-06-2009 7:55 AM
HI,
I have two queries in BW that i have use used in VC to display data in two tables.say for example i have 5 columns in table 1 and 5 columns in table 2.Now i wanted to combine two tables into a single tabel of the full 10 columns.I have used a combine operator..and got the 3rd table output with full 10 columns...but the problem here is ...when i execute the iview...iam getting only one record in the 3rd table.is there any possibility of getting all the records...in the 3rd table after combine
Thanks
P.Navakanth
Yes ...combine operator cannot be used for combining two tables ...and displaying the data into third table......
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You should use UNION operator to combine two tables. Please also note that duplicates are removed when you use UNION.
Many thanks,
Arda.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Are you using combine operator after the 2 tables? If you want to jion data of 2 tables then use the operator after the query definition & then drag the table on combination with 10 columns.
regards
Sandeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.