Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
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.
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.