To merge two data sets, use a common key to combine the rows from each set into a single data set.

• Identify a common key in both data sets to merge on

• Use a join operation (e.g. inner join, outer join) ...read more