0 Replies Latest reply: May 4, 2017 10:27 AM by Seth Yates RSS

    Join data loaded from excel to SQL data

    Seth Yates

      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;