Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Count of 1

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

(
ooxml, embedded labels, table is Sheet1);

10 Replies
Not applicable
Author

never mind!  I think it worked!