3 Replies Latest reply: Aug 25, 2016 5:22 AM by Abhishek Sen RSS

    Load data in table based on value from other tables

    Abhishek Sen

      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!