I hope this is an easy question:
I need to create a query to list information from one universe where an identifying field (Medical Record Number) is present in a personal data file (an Excel file including the list of medical record numbers for which I need information).
Everything I see in the help files about intersect queries seem to address a single universe. Is it possible to address both the universe and a personal data file in this way?
Heather
Data Coordinator
UNC Hospitals Comprehensive Transplant Center
phone: 919-966-1633
fax: 919-966-5697
hblonsky.luv1@mail.unch.unc.edu
Time is an illusion. Lunchtime doubly so.
The opinions expressed in this email are well reasoned and insightful. They are not the opinions of the State of North Carolina, any of its departments or agencies.
Heather, what you will need to do in order to relate data from two different data providers (ie, universe and personal/Excel) is to link them. So, in your report create one query from your universe and be sure to include Medical Record Number. Then insert another table into the report and choose Personal Datafile for the dataprovider source. Again, be sure to include the Medical Record Number dimension from this source. At this point your report will include two tables, each based on a different query. Choose View from the Data menu. You will see two queries. Choose one and select the Medical Record Number field. Then click on the definition tab and click the Link to button and link it to the corresponding same field in the other query. Now you can insert tables using data from the existing document and since the two queries are linked, ALL fields will be available for your selection.
I hope that helps.
Donald May
MIS Eagle Services
Pratt & Whitney
Ph: (860) 565-5253 Fax: (860) 565-4347 M/S: 117-35
E-mail: maydp@pweh.com
You wrote: > I need to create a query to list information from one universe where an identifying field (Medical Record Number) is present in a personal data file (an Excel file including the list of medical record numbers for which I need information).<…
The easiest way is to use the list of values in the universe. From the tools menu, select the universe name and list of values. Select the object (this object must have a list of values) and select the option to set the LOV to Personal Data File. Read the spreadsheet values into the list of values. When you do a condition in the query, the list of values will then be the list in your spreadsheet. You may need to do more than one condition in the query panel (depending on the number of entries in the LOV) e.g. Medical Record Number In List (…) or Medical Record Number In List (…)
Kind Regards
Annaliza Janse van Rensburg
Usko Software Group - South Africa