topic Re: If I load two tables I.e having one same column then by default which join will be applied ? in QlikView

If I load two tables I.e having one same column then by default which join will be applied ?

Wed, 20 Jan 2016 06:42:42 GMT

Test:

LOAD A,

FROM

<Path>

Test 1:

LOAD

FROM

<Path>

Re: If I load two tables I.e having one same column then by default which join will be applied ?

jonathandienst — Wed, 20 Jan 2016 08:12:27 GMT

Your script will create two tables with an association on FieldA. This is similar in effect to a full outer join

If you want to do a join, then use this to create a single table:

JOIN LOAD

FROM

<Path>

The default JOIN is a also full outer join. You can override this with LEFT, RIGHT and INNER.

Re: If I load two tables I.e having one same column then by default which join will be applied ?

sunny_talwar — Wed, 20 Jan 2016 08:13:08 GMT

Unless you specify Join, these will be kept as two separate tables with data from both tables (acting like a full outer join)

Re: If I load two tables I.e having one same column then by default which join will be applied ?

jagan — Wed, 20 Jan 2016 08:20:23 GMT

Hi,

If you do not specify any Join both the tables cannot be combined into one (two separate tables), but there will be join/relation between the tables, there is Full Outer Join between these two tables.

Regards,

jagan.

Re: If I load two tables I.e having one same column then by default which join will be applied ?

brijeshvma — Wed, 20 Jan 2016 09:01:12 GMT

Hi,

If u are not mentioning join between two table . it will keep seperate table and create synthetic key and if no of column are same and same name than automatic it will be full outer join.

Re: If I load two tables I.e having one same column then by default which join will be applied ?

Wed, 20 Jan 2016 09:05:03 GMT

Hi Sunny,

I have 853 records in Test table and 853 records in Test1 table as well . But with this code whenever I am plotting column A into the front end then row count is 854. Can you please tell me the reason behind this?

Re: If I load two tables I.e having one same column then by default which join will be applied ?

engishfaque — Wed, 20 Jan 2016 09:26:48 GMT

Dear Kapil,

QlikView does not perform any join by default.

If your two tables have one column (field) name same, then there will be Association between two tables by default.

If your two tables or more have more than one column (field) names same then there will be synthetic key created autometically then you need to create link table to remove synthetic key or you need to rename field names as the synthetic key can be removed.

However, if you would like to use join between tables then you need to use Left Join, Right Join, Inner Join and Outer Join.

Please go through and get clear understanding from listed below link,

Understanding Join, Keep and Concatenate

Kind regards,

Ishfaque Ahmed

Re: If I load two tables I.e having one same column then by default which join will be applied ?

jonathandienst — Wed, 20 Jan 2016 09:37:44 GMT

Kapil Verma wrote:

I have 853 records in Test table and 853 records in Test1 table as well . But with this code whenever I am plotting column A into the front end then row count is 854. Can you please tell me the reason behind this?

Because there is one value in Test that does not exist in Test1 and/or one value in Test1 that does not exist in Test. That means there are 854 distinct values of A. That's what is meant by a full outer join.

Re: If I load two tables I.e having one same column then by default which join will be applied ?

Thu, 21 Jan 2016 09:01:08 GMT

Thanks jonathan..

Re: If I load two tables I.e having one same column then by default which join will be applied ?

Thu, 21 Jan 2016 14:58:55 GMT

Yes,If you are not mentioning type of join then there wont be any join in qlik view but if the fields are same in different tables then there will be association.using only join will make full-outer join But, according to your requirement you can use Left Join ,Right Join,Inner Join .

Regards,

Anil