topic left join two loaded tables in QlikView

left join two loaded tables

ali_hijazi — Mon, 20 Jun 2011 11:58:39 GMT

hello I got 2 tables loaded as such

table1:

load field1, field2

sql select * from table1

table2:

load field1, field3

sql select * from table2

(the common field is field1)

what is the syntax of left join between the two loaded tables table1 and table2 ?

kaushalview — Mon, 20 Jun 2011 12:09:58 GMT

Hi,

table1:

load field1, field2

sql select * from table1

left join

table2:

load field1, field3

sql select * from table2

Regrads

Kaushal mehta

ali_hijazi — Mon, 20 Jun 2011 12:20:28 GMT

does your solution means that the table 1 and table 2 remain available but the relation between them is left join?

so does this mean that all values of field1 will appear whether ther is data related in table 2 or not?

please help?

Mon, 20 Jun 2011 12:27:07 GMT

Yes, Kaushal is correct. All the values of Field1 from Table1 will appear regardless of the data related to table2.

Where ever table2 data is not available you`d get '-' Null() as value for respective columns.

- Sridhar

ali_hijazi — Mon, 20 Jun 2011 12:44:36 GMT

the problem is that the data is very huge is I do a left join the system is killed

can't I display all values of table1 in the dimensions of a pivot table despite the fact there is related values in table 2 or not?

without doing left join

Mon, 20 Jun 2011 12:53:23 GMT

Yes, you can display. if you are not using left join between the table you`d get all the data from both the table.

i.e Field1 will have the data from both table1 and table2.

For example if you create a pivot table from only the table1 fields, you would get only the data from table1.

Linking the table in Qlikview is similar to outer join in SQL.

Hope this helps you.

- Sridhar