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

Join data loaded from excel to SQL data

I am loading data from excel and SQL and need to join the two data sets.  The common field is the EMP_ID (SID) and Called SID.  The data below loads fine until I add a join.  Any help would be greatly appreciated.

Thanks,

Seth


Directory;
ImplementationRTT:
LOAD [Ticket ID],
Description,
Priority,
Platform,
Queue,
Class,
Status,
Application,
Function,
[Root Cause],
[Time Worked (minutes)],
(
[Time Worked (minutes)] / 24) / 60 AS [Time Worked (h:mm)],
Assignee,
[Assignee Ctry],
Caller,
[Caller SID],
[Caller Ctry],
DATE(Date#([Creation Date],'DD/MM/YYYY'),'MM/DD/YYYY') AS [Creation Date],
YEAR([Creation Date]) AS [Creation Date Year],
MONTH(DATE(Date#([Creation Date],'DD/MM/YYYY'),'MM/DD/YYYY')) AS [Creation Date Month],
DAY(DATE(Date#([Creation Date],'DD/MM/YYYY'),'MM/DD/YYYY')) AS [Creation Date Day],
WEEKDAY(DATE(Date#([Creation Date],'DD/MM/YYYY'),'MM/DD/YYYY')) AS [Creation Date Week Day],
WEEK(DATE(Date#([Creation Date],'DD/MM/YYYY'),'MM/DD/YYYY')) AS [Creation Date Week],
'Q' &
CEIL(MONTH(DATE(Date#([Creation Date],'DD/MM/YYYY'),'MM/DD/YYYY'))/3) AS [Creation Date Quarter],
CEIL(MONTH(DATE(Date#([Creation Date],'DD/MM/YYYY'),'MM/DD/YYYY'))/3) AS [Creation Date Quarter No],
Today() AS [Current Date],
YEAR(Today()) AS [Current Year],
(
YEAR(Today())-1) AS [Previous Year],
MONTH(Today()) AS [Current Month],
DAY(Today()) AS [Current Day],
WEEKDAY(Today()) AS [Current Week Day],
WEEK(Today()) AS [Current Week],
'Q' &
ceil(month(Today())/3) AS [Current Quarter],
ceil(month(Today())/3) AS [Current Quarter No],
Date(MonthStart(Today()), 'MMM-YYYY') AS [Current Month Year],
'Q' &
ceil(month(Today())/3)&' '&YEAR(Today()) AS [Current Quarter Year],
inyeartodate(Today(),Today(),0) * -1 AS [Current YTD],
inyeartodate(Today(),Today(),-1) * -1 AS [Previous YTD],
Today() - DATE(Date#([Creation Date],'DD/MM/YYYY'),'MM/DD/YYYY') AS [Day Count],
[Creation Time],
[Creation Month],
DATE(Date#([Last Updated Date],'DD/MM/YYYY'),'MM/DD/YYYY') AS [Last Updated Date],
//[Last Updated Date],
   [Last Updated Time],
[Last Updated Month],
DATE(Date#([Resolution Date],'DD/MM/YYYY'),'MM/DD/YYYY') AS [Resolution Date],
//[Resolution Date],
   [Resolution Time],
[Resolution Month],
[Resolved By],
DATE(Date#([Closure Date],'DD/MM/YYYY'),'MM/DD/YYYY') AS [Closure Date],
//[Closure Date],
   [Closure Time],
[Closure Month],
[Closed By],
[Age (Creation to Now)],
[Age (Creation to Closure)],
DATE(Date#([Request Start],'DD/MM/YYYY'),'MM/DD/YYYY') AS [Request Start],
//[Request Start],
   DATE(Date#([Request End],'DD/MM/YYYY'),'MM/DD/YYYY') AS [Request End],
//[Request End],
   [Resolution Code],
[External ID],
[PostRelease Issue],
[Peregrine ID],
[Priority Number],
'Implementation'
AS Team
FROM
[Implementation RTT.csv]
(
txt, codepage is 437, embedded labels, delimiter is ',', msq);

ODBC CONNECT32 TO DailyDatamart;

CallerCoverage:
  SQL SELECT
  EMP_ID AS SID,
  HCS_LOB_NODE06_DESC_TXT AS LOB,
  HCS_LOB_NODE07_DESC_TXT AS Region,
  HCS_LOB_NODE08_DESC_TXT AS Market
  FROM vw_hr_phone_book;

0 Replies