topic Why name tables when doing Joins? in QlikView

Why name tables when doing Joins?

Mon, 08 Feb 2016 17:02:41 GMT

In the following load script, I'm attempting to join resident table "Table_2" onto "Table_1":

Table_2:

Left Join (Table_1)

Load *

from [$desktop\Table_2.xlsx] (ooxml, embedded labels, table is Sheet1)

Why is the resulting table still named "Table_1"? What is the purpose of the "Table_2:" line in the loading script?

Thanks!

Re: Why name tables when doing Joins?

Gysbert_Wassenaar — Mon, 08 Feb 2016 17:39:07 GMT

There is no purpose to try to give a name to a table that won't exist after you join it to another table. Don't do it. You'll only confuse yourself and anybody trying to read your code.

Re: Why name tables when doing Joins?

Mon, 08 Feb 2016 19:06:06 GMT

It will helpful if you want join previous loaded loaded table which is not last loaded table. If you don't specify it always join last previously loaded table.