Compare Two Dimension Object

[system]

Hi all,

I have two data providers, i want to compare client name. How to compare two dimension object.

client name(d1) = client name(d2). I want to display only both client are equal.

Regards,
Vish

---

visu (BOB member since 2005-05-31)

[system]

Create a new variable, with an if statement.

I don’t know the exact code, but it should look something like :

= IF (client name(d1) = client name(d2)) then client name(d1) else 'nothing'

The code is not 100% correct I think, but it should look something like this.

Is this a solution to your problem ?

---

woeters (BOB member since 2005-12-14)

[system]

I tried the same. But its display all the client name in d1, not matching one.

---

visu (BOB member since 2005-05-31)

[system]

Reporter FAQ:

FAQ: Reporter

How can I make a table from two data providers and only show data common to both? Once they are linked, each object of linked data providers contains ALL of the values from BOTH queries. If you want to isolate the display to show only records that are in both queries, you need to filter for non-null values from some other non-linked value. For example, assume you have measure M1 from query 1, and measure M2 from query 2. Measures work the best, but detail object can be used also. You n…

---

Mahi (BOB member since 2004-07-22)