JOIN

[#1]

I need to join 2 table that have a common field

how can i do?

[oknotsen]

Type "join" before the LOAD of the 2nd table.

Qlik will find the find they have in common and automatically join on that field.

[Colin-Albert]

You don't need to do anything.

If the two tables share a common field name then QlikView will associate the tables automatically.

The best approach in QlikView is to avoid using joins as far as possible.

[sunny_talwar]

May be this:

Table1:

LOAD FieldNames

...

FROM Source1;

Join (Table1)

LOAD FieldNames

...

FROM Source2;

Understanding Join, Keep and Concatenate

[Anonymous]

Hi Federica,

Qlikview internal associative engine will automatically join tables that have same fieldnames.

If the fieldnames are different but pointing to same values, you just have in your loading script to make sure they become the same by renaming with "as" linkey:

LOAD field1,

          field2 as linkey,

...

Best

Maurice

[Anonymous]

You need to join the two tables ( using function JOIN ) only if you want all the fields in one table.

Otherwise, if you have a commun field, QlikView will associate the two tables automatically but you will have two separate tables.

Do you need to have only one table or to keep your two tables?