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.
