Association and Full outer join - non key fields

[#1]

Hello All,

PFB the scenario.

t1:

  load * inline

  [

   id

  1 

1

  ];

   // outer join(t1)

  load * inline

  [

   id, time

    1,   t1

   1,   t2

];

-**********************************************-

The above dataset when we leave the tables as such and let them associate based on id, the count(id) is 2.

whereas when we give a join(full outer) the count(id) is being shown as 4.

So, association is not same as full outer join in this case?

Need your thots on this.

Regards,

Priya

[petter · Accepted solution]

You are right: Association and Outer Join is not the same.

Sometimes they are sometimes they are not. Henric Cronström has explained that on this forum I remember. He explained that associations are quite a bit more dynamic so it is not only how the data are associated in the data model but also how the selections are made that determine the results you get in the user interface. So in some cases it might even be a left join depending on the charts composition and the selections...

[buzzy996]

in roughly, Association will happen based on same field names automatically but joins(outer) will happen based on data.

[#4]

Thanks for the reply.

Could you please share the explanation by Henric Cronström?

Searched for it, but couldnt get the post.

Thanks!

[buzzy996]

hopes i'm not wrong here,the explanation is same as I SAID ABOVE