topic Re: JOIN in QlikView

JOIN

Wed, 25 Nov 2020 16:16:04 GMT

I need to join 2 table that have a common field

how can i do?

Re: JOIN

oknotsen — Mon, 21 Mar 2016 14:26:09 GMT

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

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

Re: JOIN

Colin-Albert — Mon, 21 Mar 2016 14:27:47 GMT

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.

Re: JOIN

sunny_talwar — Mon, 21 Mar 2016 14:29:28 GMT

May be this:

Table1:

LOAD FieldNames

...

FROM Source1;

Join (Table1)

LOAD FieldNames

...

FROM Source2;

Understanding Join, Keep and Concatenate

Re: JOIN

Anonymous — Mon, 21 Mar 2016 15:11:40 GMT

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

Re: JOIN

Anonymous — Mon, 21 Mar 2016 15:16:27 GMT

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?