Not Inner join then left join

ferha_jafri — Fri, 29 Jul 2022 09:59:07 GMT

Hello Experts,

I have an SQL Query on inner join, as r.fcs_nr = jcs.fcs_nr(+), the result of this query says that if ineer join do not have anything common, it will take the prior table. I want to know how we can impliment similar condition in qlik scripting. i.e. if the result of innner join is nul then it will take prior table.

Thanks in advance

Ferha

Re: Not Inner join then left join

marcus_sommer — Fri, 29 Jul 2022 12:10:39 GMT

You could apply the inner join and checking then within an if-loop the noofrows('YourTable') to do anything different or just to continue with your script.

- Marcus

topic Re: Not Inner join then left join in App Development

Not Inner join then left join

Re: Not Inner join then left join