Join Multiple Query

[tandon]

I am trying to use Join Multiple but not clear on output. I understand - it return Cartesian Product but not sure whether it;s the case.

As per Cartesian product - I expect 60 records. please can someone elaborate how to read it. I gone through explanation but missing it.

I have below

Table 1                                      

                         

Table 2  

Table 3

and it returned 9 records as output (when I selected "allow all multidimensional joins")

[IraWatt]

Hey @tandon,

Because your joining on field1 that means only fields in field1 with the same value will join. So for the cartesian join you will expect 2*2*1 rows for 1, 2*2*1 for rows 2 and 1*1 rows for 3. 

Append fields on the other hand will do the full cartesian join irrelevant of field values:

Any questions or issues please ask :)
HTH!
Ira

[tandon]

Thanks @IraWatt . please can you elaborate how did we arrive on 2*2*1 for 1, 2*2*1 for 2 and 1*1 for 3.

[IraWatt · Accepted solution]

No worries @tandon, table 1 has 2 rows with a value of 1, they will join onto 2 rows containing 1 in table 2 and 1 row of value 1 in table 3. In Cartesian joins the number of rows you get is a multiplication for the number of joined rows, hence why you get 4 rows of value 1 here:

[tandon]

Perfect. It's clear now for me. Thanks again