Hello Joe,
The main issue here I can see at a first glance is that you are loading from QVD files with the same syntax you where doing in a SQL statement, and this is not correct.
The following line is what I'm guessing is throwing the error (you can check that in a debug load)
FROM
[QVD\QVFACT.qvd](qvd) fact, [[QVD\QVCSCM.qvd](qvd) cscm
Everything after the "(QVD)" that is not a LOAD sentence (WHERE mainly, but there are other you can check in the Reference Manual) is not understood by QlikView.
You don't need to specify where to join in QlikView. Well, you do, but QlikView uses named-alike fields to create a relation between both tables.
Assuming your code, my guess is that you should do something like the following much simplified example (joining tables using where and loading only some of the records):
Table1: // First table
LOAD * INLINE [
Code, Name
1, AAA
2, BBB
3, CCC
];
Table2: // Second table, the key field "C" should be renamed so the fields can be associated by QlikView
LOAD C AS Code, Data INLINE [
C, Data
1, 10000
2, 20000
3, 30000
4, 40000
]
WHERE EXISTS(Code, C); // Ok, but only those records for what this tables's "C" field values
// already exist in the previously loaded table "Code" field
Although I'm using INLINE loading instead of using QVDs, the syntax is valid anyway. The result of the code above are two tables associated by field "Code", so any selection you do in the first will affect the second table. That's how the associative logic (the magic behind QlikView) works. If you don't want two tables you can JOIN them and put into memory only one table. That will work too adding the "JOIN" keyword before the second LOAD statement.
Hope that helps.
Miguel Angel Baeyens
BI Consultant
Comex Grupo Ibérica
.png "Miguel_Angel_Baeyens"){kind=avatar}
