Discussion Board for collaboration on QlikView Scripting.
I'm a QLikView learner.
I was just eager to know whether
Load * from Table1;
Load * from Table2;
Load * from Table3;
is same as-----------------------------------------------
Load* Resident Table1;
Load* Resident Table2;
Load* Resident Table3;
Drop Tables Table1, Tabl2, Table3;
As long as Table1, Table2, Table3 don't have the same fields, so they would autoconcatenate in the second case...
And your resulting table is differently named in the two cases.
I do have a key with same name in 3 tables which joins 3 of the tables.
No, I was talking about autoconcatenation, QV will automatically concatenate tables when they show the same number and names of fields. This will not happen if the tables only share a subset of fields (like a single key field).
I'm not able to understand the response.
After script execution, there will be only Table1 in your data model, because of auto-concatenating the two tables (same number of fields and fields have same name, all fields are keys).
If you want to prevent this, use NOCONCATENATE LOAD prefix:
But now the two tables are linked by two fields --> synthetic key is created.
So I think swuehl means that if the name of the fields between the three tables are exactly the same, they will auto-concatenate. These two can be safely considered equivalent:
No problem Mark
Glad we were able to help.