title: Merge only Missing Data
body: <p>I am working on an HR project that provides data to me in the form of an Excel document. </p>
  
  <p>I have created a package that captures the data from the Spreadsheet and imports it into SQL. The customer then wanted to create a data connection and place the data into Pivot Tables to manipulate and run calculations on. </p>
  
  <p>This brought to light a small issue that I have tried to get fixed from the source but looks like cannot be resolved on the System Side (working with an SAP backend). </p>
  
  <p>What I have is information that comes into SQL from the import that is either missing the Cost Center Name or both the cost center number and the cost center name. </p>
  
  <p>EXAMPLE:</p>
  
  <pre><code>EmpID    EmployeeName    CostCenterNo    CostCenterName
  001      Bob Smith       123456          Sales
  010      Adam Eve        543211          Marketing
  050      Thomas Adams    121111
  121      James Avery     
  </code></pre>
  
  <p>I worked with HR to get the appropriate information for these employees, I have added the information to a separate table. </p>
  
  <p>What I would like to do is figure out a way to insert the missing information as the data is imported into the Staging table. </p>
  
  <p>Essentially completing the data. </p>
  
  <pre><code>EmpID    EmployeeName    CostCenterNo    CostCenterName
  001      Bob Smith       123456          Sales
  010      Adam Eve        543211          Marketing
  050      Thomas Adams    121111          Supply Chain
  121      James Avery     555316          Human Resources
  </code></pre>