Qlikview default join (Associate) Vs Join between tables

[narender123]

Hi All,

I have 2 tables.I want to merge it into one via join.

Case1:-

table a:

ref,

amount,                               

----

from table a;

table b:

ref,

Tax,

----

from table b;

Qlikview by default creating the join via ref and showing right data.

--------------------------------------------------------------------------------------------------------

Now i want to merge both table into 1 via join ref.

Case2:-

table a:

ref,

amount,

----

from table a;

join

table b:

ref,

Tax,

----

from table b;

But it is showing wrong data.What should i do to show right result during merging into 1 table.

table b having multiple entries of ref.But table 1 having single entry of ref.

Please suggest me to sort out this.

Thanks,

[Anonymous]

I tried the described approach with my sample data and it gives me same result both using association and join.

Can you share your sample file if possible, which helps me to investigate further?

Attached the file where I tried the scenario.

[Anonymous]

see this for better understanding:

Understanding Join, Keep and Concatenate

[narender123]

Hi Leni,

I cant show.

Thanks,

[narender123]

Can you tell me which one is the exact join for the qlikview default (automatic) join?

As i already used these joins but no success.           

Thanks,

[maxgro]

don't join

tablea:

load * inline [

ref, amount

1, 1

2, 2

3, 3

];

join

// tableb

load * inline [

ref, tax

1,1

1,11

2,2

2,22

3,33

];

I think you're replicating the amount when you have the same ref in tableb and the sum is wrong

[Anonymous]

By default QV takes Full Outer Join which may mismatch your data.

Also, while joining two table check their Information Denisty and & Subset Ratio

information density and subset ratio? What is the use of this?

Table with more Information Denisty and & Subset Ratio will be like a parent table for you

[narender123]

Hi Maxgro,

I need to join them and make them one table.

and my expression is like eg:-

= sum(amount)+sum(tax)

[narender123]

Hi Balraj,

You are right my data is taking full outer join records when i joined them. but i need records just like in qlikview default (automatic) join.Because my target is to merge into one table via joining .

Thanks,

[Anonymous]

Instead of join, you can use Mapping Load as well....with applymap()..

see this:

Don't join - use Applymap instead