i am joining two table and after joining i will to drop second table.
please see the below code for you reference.
[ACD Report]: LOAD [CALLS], [ABANDONED], [HANDLE TIME], [HOLD TIME], [AFTER CALL WORK TIME], [DISPOSITION], [CALL ID] AS [CALL ID-CALL_ID]] FROM [lib://Report (NY_manoj)/LOB_MGR ACD Report.csv] (txt, codepage is 28591, embedded labels, delimiter is ',', msq);
Left join
[VCC_CALL_LOG]: LOAD [CALL_ID] AS [CALL ID-CALL_ID], [DATE_OF_CALL], [SURVEY_BEN_COUNSELOR], [SURVEY_CONTACT_CTR], [SVL1];
SELECT "CALL_ID", "DATE_OF_CALL", "CALL_TYPE", "CALLER_SVC_LEVEL_THRESHOLD", "QUEUE_CALLBACK_WAIT_TIME", ISNULL("CALLER_SVC_LEVEL_THRESHOLD",'45') as SVL1 FROM "CALL_LOG" WHERE DATE CALL>='05/01/2021' and DATE_OF_CALL<='05/31/2021';
