Merge 2 datasets,no duplicates ?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

hello
i have 2 data sets and i only want to put the data from ds2 into ds1 that
isn't in ds1 already,
i used merge but that just appended the whole ds2 into ds1, is there a way
to just append the ones that don't alreadyexist in ds1.


thank you
 
GATMAN,

You may want to consider writing a function to merge the records with your requirements.

-Calvin Luttrell
ProjectThunder.com, Inc.
nothing is impossible
 
Try creating a primary key on the column and merge the
matches should be updated, if no matches then it will be added

Anubhav Mishra
 
Back
Top