Issue with Joins

Wed, 25 Nov 2020 16:16:04 GMT

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;

Re: Issue with Joins

Clever_Anjos — Wed, 03 Aug 2016 17:03:31 GMT

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

Re: Issue with Joins

Wed, 03 Aug 2016 20:22:56 GMT

thanks Anjos its really helpful

topic Re: Issue with Joins in QlikView

Issue with Joins

Re: Issue with Joins

Re: Issue with Joins