In a message dated 99-06-22 16:55:30 EDT, you write:
[ stuff deleted ]
First table from Query 1 in the universe:
Dimension A Dimension B Measure C
=====================================
A1 B1 C1
A2 B2 C2
[ stuff deleted ]
Second table from Excel Spreadsheet
Dimension A Detail D
======================
A2 D2
[ stuff deleted ]
These data providers are linked manually on Dimension A. Now if I drag the values of Detail D from the spreadsheet table to the universe table, I get:
Dimension A Dimension B Measure C Detail D
===============================================
A1 B1 C1
A2 D2 <=== it ADDed this row instead of combining it with the next row A2 B2 C2
[ more stuff deleted ]
The reason your data is not being combined the way you expect is that your “keys” are not identical, probably with extra spaces at the end. Try to make sure that your spreadsheet has the contents “A2” and not "A2 ", and do
the same for your query. Based on the sort order in your example, I suspect that your database value is the one with the extra trailing spaces (“A2” being less than "A2 ") since it showed up second.
You can manually adjust your spreadsheet entries, and you can use the “Delete Trailing Blanks” option on the query panel to fix the data from the query. In fact, that was the reason that option was added! To access the query options, open your query and click on the “Options” button in the lower left-hand corner of the screen.
I can’t think of anything else that would be causing this problem.
BTW, be aware that if you have the following keys in your query
A1
A2
A3
A4
… and these keys in your spreadsheet
A2
A4
A6
A8
… Then you will see the following in your “joined” query:
A1
A2
A3
A4
A5
A6
A8
In other words, it will be a combination of all of the values, not just the values from one query or the other. There have been a number of posts on why this is the case, so I won’t go into it again here. You might search the archives for combined data provider outer join issues.
Regards,
Dave Rathbun
Integra Solutions
www.islink.com
PS - Here’s a quick way to verify if your database fields have spaces in them or not…
Assume you have variable X from your query Create a new variable called X2 with the following formula:
= “[” & & “]”
By concatenating the brackets around the value of X, you will see something like this if there are no spaces:
[A2]
… and this if there are spaces:
[A2 ]
That should confirm your situation!
Listserv Archives (BOB member since 2002-06-25)