Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me to convert this query into qliksense script using qvds tables
Where pis7.ap_invoice_num not in (select invs7.invoice_num from ap_invoices_all invs7 where INVs7.SOURCE = 'Oracle Property Manager')
Table1:
Load
invs7.invoice_num as invoice_num,
...
from ap_invoices_all invs7 where INVs7.SOURCE = 'Oracle Property Manager'
Load
invoice_num,
...
from frist Table where not EXISTS(invoice_num,invoice_num) ;
drop table table1;
hope this helps
I don't get proper solution by this step.