BusinessObjects Board

Equi join in Linked Dataproviders?

building reports desktopintelligence
#1

Hi All,
Let me explain my requirement first.
I have two data providers. I need to display some fields from both the DPs in a single table. When i link the two DPs based on a common field, and drag the fields from both the DPs in the table, i would get a union of all the records in both the DPs, thereby givin me unnecessary records in the table. But what i need is an equi join of the two DPs based on the ID that is linking the two DPs.
How could i achieve this.
TIA,
Sunil

sunil somanna (BOB member since 2005-10-18)

#2

Moved to BO Classic forum.

Nick Daniels :uk: (BOB member since 2002-08-15)

#3

Maybe filter data out by using a Filterdefinition like

=Not IsNull(<Column DP1>)

jobjoris :netherlands: (BOB member since 2004-06-30)

#4

try this one
create a variable -
not isnull()

bo4me2know (BOB member since 2005-07-21)

#5

Please read the FAQ

Dave Rathbun :us: (BOB member since 2002-06-06)

#6

Sunil,

If I understand your problem correctly, you are having 1 row with a (detail)field from DP1 and 1 row with a (detail)field from DP2 instead of 1 row with the (detail)fields from both DP’s.

Probably the ID from both DP’s are not the same.
Maybe there is a space-character after the ID in 1 of the 2 DP’s
I have encountered this more than once.
The solution was in (un-)checking the option ‘Delete trailing blanks’ in both DP’s.

Hope this helps.
Johan

JdVries :netherlands: (BOB member since 2006-02-06)