Skip to main content
Question

Lookup data from 1st & 2nd table and enter matched data based on Unique ID into 3rd table

  • February 20, 2019
  • 0 replies
  • 129 views
Hi,

I have Total three table ie. Table1, Table2 & Table3 
in the first two table i'm importing data from excel (local pc)
in the Table1 & Table2 there is Unique_ID column
after importing data into Table1 & Table2 automatically lookup the data from both the table and add the Matched data into Table3. 

Note: Also check for existing Unique_ID into Third table and skip those record by adding into Table3 
    This topic has been closed for replies.

    • JakeRattner2
    • Registered
    • March 9, 2019
    Will table 3 only contain matcher records from tables 1 and 2? Or will you need to manually add date to table 3? 
    Terms & ConditionsAccessibility statement