after left join how to drop second table in qlik sense

manojin123 — Tue, 30 Nov 2021 18:17:33 GMT

Hi All,

Hope you guys help me on this.

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

Re: after left join how to drop second table in qlik sense

rubenmarin — Sun, 18 Jul 2021 07:43:06 GMT

hi, when you do a left join you end with only one table combined, the 2 original tables are dropped. Using left keep you can keep both tables, but with join you end with only one table.

Re: after left join how to drop second table in qlik sense

manojin123 — Tue, 20 Jul 2021 11:38:05 GMT

Thank you

topic Re: after left join how to drop second table in qlik sense in App Development

after left join how to drop second table in qlik sense

Re: after left join how to drop second table in qlik sense

Re: after left join how to drop second table in qlik sense