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.
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;