Hi,
I am trying to make a comparison between 2 queries that pull the same data object from 2 separate project. I am trying to create some sort of change management report that will mark in red all the objects that appear in the first query and do not appear in the second query and vice versa… Does anybody have a solution to this?
Regards,
Ronen Baran, System Analyst
Tecnomatix LTD.
Mail to : rbaran@tecnomatix.com
Telephone : 09-9594856
Listserv Archives (BOB member since 2002-06-25)
X-cc: “Welch, Louise” lw55772@glaxowellcome.co.uk
I would like to know an easier answer, however…
Listserv Archives (BOB member since 2002-06-25)
Are your two queries from the same universe? If so, you could create reports using sub queries. For example, Project 1 query could have a condition on where not in list of Project 2 query.
Shelley
I would like to know an easier answer, however… --------------------------------------------------------------------------
I am trying to make a comparison between 2 queries that pull the same data object from 2 separate project. I am trying to create some sort of change management report that will mark in red all the objects that appear in thefirst query and do not appear in the second query and vice versa… Does anybody have a solution to this?
The steps below will display a report containing a union (full outer join) of all records from both queries, and highlight those that occur in one but not the other. I found this tricky to do with variables since whenever you reference both linked variables in a table, then they both simultaneously contain all values. Using an alerter seems to work however :-
Listserv Archives (BOB member since 2002-06-25)