Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team ,
I have written a query which is perfectly executing ,when im using in the script its throwing error , I assumed initially it was DB error but rest of the Queries are executing and loading from same DB .
kindy suggest if any errors or catch points where qlikview is not allowing it.
Please find the attached Screen print .
select * from
(select intf.ext_interface_nm PHWEB_INTERFACE_NM,
SLA_THRESHOLD PHWEB_THRESHOLD,
CUTOFF_SLA_THRESHOLD PHWEB_CUTOFF,
to_char(ft.reception_dt,'mm/dd/yyyy') RECEPTION_DATE,
to_char(ft.reception_dt,'hh24:mi:ss') PHWEB_INTIME
from zyadm.zy_interface_t intf, zyadm.zy_file_t ft
where intf.interface_id = ft.interface_id
and ft.reception_dt> = sysdate-7
and ft.interface_id = 1000) PHWEB
LEFT OUTER JOIN
(select intf.ext_interface_nm GPSY_INTERFACE_NM,
SLA_THRESHOLD GPSY_THRESHOLD,
CUTOFF_SLA_THRESHOLD GPSY_CUTOFF,
to_char(ft.reception_dt,'mm/dd/yyyy') RECEPTION_DATE,
to_char(ft.reception_dt,'hh24:mi:ss') GPSY_INTIME
from zyadm.zy_interface_t intf, zyadm.zy_file_t ft
where intf.interface_id = ft.interface_id
and ft.reception_dt> = sysdate-7
and ft.interface_id = 1003) GPSY
ON GPSY.RECEPTION_DATE = PHWEB.RECEPTION_DATE;
That´s because you have RECEPTION_DATE in both query´s
Select * will bring RECEPTION_DATE twice that Qlik does not permit.
Never user select *, list only the fields you want
thanks Anjos its really helpful