Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Load data in table based on value from other tables

Hi,

I have a table to load. The condition to load this table is the particular column's value is not available in previously loaded tables. For example:
Two previously loaded tables:

AR_Table:

IDVendor_Trans_IDAR_Amt
1V001100
2V002200
3V003300
4V004400

AP_Table:

IDInvoice_IdAP_Amt
1AP001500
2AP002600
3AP003700
4AP004800

Now I want to load a final table in which I have Vendor_Trans_Id and Invoice_Id. Condition to load records in this final table is Final_table.Vendor_Trans_Id<> AR_Table.Vendor_Trans_Id and its Final_Table.Invoice_Id<>AP_Table.Invoice_Id

Thanks!

Tags (1)
3 Replies
squeakie_pig
Contributor

Re: Load data in table based on value from other tables

Use Not(Exists) function

agomes1971
Valued Contributor

Re: Load data in table based on value from other tables

Hi,

please read this

Not Exists() | Qlik Community

HTH

André Gomes

Not applicable

Re: Load data in table based on value from other tables

Ok.. I used Exists

But I see some strange result. That is, if my "final" table has duplicate rows, by Invoice_id and if this Invoice_id not present in AP_Table....the result I get is only one row and not the duplicate rows in the final table.

As per my requirement I should get both the rows if Invoice_Id is not present in AP_Table.

Community Browser