Inner Join in IDT

building semantic layer
1

Can anyone tell me how to make an innerjoin in Information Design Tool?

(Preferably with a screenshot)

I tried this

TMP_CL_CONTACTEN1.CLIENTID=TMP_CL_CASUSFORMULIER1.CLIENTID

with cardinality set 1:1 but it doesnt work.

The result when i show 2 fields on both sides of the join they are both empty which i think shouls be the opposite

tantetruus (BOB member since 2008-11-11)

2

It’s an inner join unless one of the two “Outer join” checkboxes is checked.

The cardinality setting has no bearing on how the join is defined.

joepeters :us: (BOB member since 2002-08-29)

3

ok?

i’ll have a go at that, thanks:)

tantetruus (BOB member since 2008-11-11)

4

i tried this, bit i when i try to view 2 variables of the two joined tables in IDT i get no result on both of them.

What do i do wrong?

tantetruus (BOB member since 2008-11-11)

5

How are you viewing the results – with a query in the BL? Take a look at the generated SQL – that might indicate where the problem is.

joepeters :us: (BOB member since 2002-08-29)

6

you mean this?

TMP_CL_CASUSFORMULIER1.CLIENTID=TMP_CL_CLIENTFORMULIER1.CLIENTID

tantetruus (BOB member since 2008-11-11)

7

You said you are seeing no results – where? Is that in a query in IDT or in WebI?

joepeters :us: (BOB member since 2002-08-29)

8

Hi,
this is a viwe of the values in IDT
IDT waarde.JPG

tantetruus (BOB member since 2008-11-11)

9

So you are looking at the values of the object in the BL? What is wrong with the result?

In that same right-click menu, there is an option for “Show Query Script”. That will display the actual SQL that’s generated for the object – that might help you understand what it’s doing.

joepeters :us: (BOB member since 2002-08-29)

10

normally,
there is at least a long list of clientid’s
When i make a join i can see these clientid’s and then combine these with a field from the other tabele to check or the join is doing what it should.
In some casees only the client id’d show, in other cases, only the field from the other tbel show which tells me that i use the wrong type of join.

In this case, none of the 2 tables show anything at all

tantetruus (BOB member since 2008-11-11)