I created a table, Table1 with 1 field in it, called Field1.
I then pull data from another source, table2 that contains the the same data in field one of table1 but also has additional data.I want to add the data from table to, to table1, where it does not already exist in table1. I am having trouble using the where not exist. My script looks like this,
Thanks I figured out the issue, but based on my previous code I now need to concatenate table1 with 4 fields and table 2 with 4 fields and I have yet to be sucessful. The fields all called the same in each table, and I want to add the records from table 2 to table 1 that are not already in table 1. I have tried a couple of things and I'm just missing something. Can you send me the script example? Thanks again, Sean
Well in that case it seems that 4 fields constitute a unique record instead of 1. We can still proceed with the same logic as before, but this time using in addition a new field formed of those 4 fields as shown below:
In the above code I used the Qualify/Unqualify in order to keep both of table2 and table1 (updated) in the tableviewer without creating synthetic keys since the fields in both tables have same names (you can also rename each field in one of the two tables instead of using the qualify/unqualify and then in the concatenate part you adjust the field names appropriately, it's up to you).
If you want instead to drop table2 in the end since table1 will contain all needed records then you can use the code below: