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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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!