Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'd like to add a column in my first load for [Emp Count] = 1, similar to what I am loading in the concatenated file. All it is, is a column that has a "1" in it. How do I do this?
CONNECT32 TO compositesw (XUserId is RAcQbXFMTLaGHMB, XPassword is UYPLRIVOBDbGWXVNNDMCDEC);
LOAD
"HOME_DEPARTMENT" as DEPT_ID,
"QC_EMP_NUM" as [Emp Num],
"EMP_FULLNAME" as [Employee Name],
"WORK_WEEK_ENDING_DATE" as weekkey,
"TOTAL_OT1_HOURS" as [Total Hours];
SQL SELECT *
FROM ENG."QTIME_SOURCE"."QTIME_SOURCE_13MONTH"
where WORK_WEEK_ENDING_DATE = '2014-01-24 00:00:00'
and TOTAL_OT1_HOURS > 0;
Concatenate
LOAD
Dept# as DEPT_ID,
[Emp Num],
[Emp Count],
[Employee Name],
[Work Week Ending],
[Work Week Ending] as weekkey,
[Total Hours]
FROM
(
never mind! I think it worked!