Qlikview Scripting Join and Store function.

[QlikView_99]

Hi All,

I've stuck with a problem in joining two tables and storing the main table into the CSV, where i cannot get the joined table contents.

Here is the brief,

there are two table where i get the data from and I have a joining table where i need to get the data from it and store all of these into CSV.

[fulldata]:

Load

empno,

empname,

empage,

empsal

from C:\Data\EMP1;

concatenate

Load

empno,

empname,

empage,

empsal

from C:\Data\EMP2;

left join ([fulldata])

[deptfile]:

load

deptno,

deptname,

empno

from C:\Data\Dept;

store [fulldata] into C:\Data\output.csv(txt);

the output csv is with the columns empno, empname, empage, empsal, deptno, deptname

but there is no data getting populated in deptno and deptname columns.

[dplr-rn · Accepted solution]

that seems odd.

In your qvw does the data appear?